1 what is the difference between set and let in qlikview

Learn more. Asked 5 years, 2 months ago. Active 5 years, 2 months ago. Viewed times. Any help would be appreciated. Improve this question.

Ben Ben 35 4 4 bronze badges. Spell Checker did me in on that. Hi Ben, and welcome to Stack Overflow. If you need to change the title, go right ahead and edit your question to fix it! This site encourages editing and re-editing of questions and answers until they're as good as they can be.

While you're there, can I suggest that you do a bit of restructuring of the question body - it's quite difficult to understand, with all the detail in one dense paragraph. Thank you for the feedback. I am editing the question now. I think I get where I went wrong in my explanation. Add a comment. Active Oldest Votes. Improve this answer. Ben 35 4 4 bronze badges. I think this is definitely part of what I need.

I've switched to ST3, further development will be focused on that platform. Basic functionality syntax highlighting for qvs files and expression files should work on ST2.

Skip to content. Star Set of tools for QlikView development in Sublime Text 3 53 stars 17 forks. Branches Tags. Could not load branches. Could not load tags. This branch is up to date with master. This branch is not ahead of the upstream master. Open pull request. Latest commit. Git stats commits. Failed to load latest commit information.

QlikView variables. View code. The options you have are unlimited. I hope you have found this post useful. If so, please share with other people. Also, you are welcome to write your comments in the form below! Qlik Set Analysis Cheat Sheet.

I consent to be contacted via email for the purpose of new articles, updates and marketing. I'm also the author of the Lean Data Processing online course, focused on building optimized data pipelines in QlikView and Qlik Sense. I like to use the current selections to find the selected date range and subtract a year from that. This way I can more precisely override the selection on ALL date dimensions, something like this.

So I am selecting the specific order dates so if the user does something weird with the selections I still get the answer I was trying to achieve, in this case it was Prior MTD. Hi Chris, thanks for stopping by and leaving your comment. Also, where do you specify which field you are assigning the value to?

I think there are certain parts missing in the set expression but woul be glad to be proven wrong, since I recognize this as something new I can learn from.

Excellent explanation. Regarding previous quarters, months and weeks, in my time dimension I generate an ID for each unique quarter, month and week using an AutoNumber. For example:. Now if I want to retrieve the previous quarter for Q1 I only need to take the max ID and subtract 1, e. Rereading my comment, I see that set analysis expressions are not correctly parsed. All the code between angle brackets is removed.

Thanks Barry! That will be my next topic. As for the syntx on the comments, I will check it out and see if there is something I can do to fix it. So now, we will combine the acquired knowledge to deliver a real-life application of Set […].

This is very useful information.