Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
QuestionAndAnswer
Contributor II
Contributor II

Dollar Sign used at beginning of set expression {$<

Hi everyone, apologies if this has been answered previously.

I joined a new project and am having trouble understanding what a dollar sign in between the first curly brace and carrot in the expression does. I understand what it means when used with a variable or formula, determines if the variable/formula is evaluated before the expression. But I'm not sure how that would work in this context. Here's an example:

num(
sum({$<Company={'Company A'},WeekEnding={'$(vMaxWeek)'}>}[Net Sales])
,'$#,##0)

What would be the difference between the above expression and this expression (removed the first $):

num(
sum({<Company={'Company A'},WeekEnding={'$(vMaxWeek)'}>}[Net Sales])
,'$#,##0)

Thanks

Labels (1)
1 Solution

Accepted Solutions
sbaro_bd
Creator III
Creator III

Hi @QuestionAndAnswer ,

No difference, put a dollar sign or let it blank is the same. Dollar $ for a set analysis means "for the active selections" to refer to your filters. The opposite for dollar-sign is 1 that means "disconnect your expression from all active selections", the calculations are performed on whole data.

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysi...

Regards.

View solution in original post

3 Replies
sbaro_bd
Creator III
Creator III

Hi @QuestionAndAnswer ,

No difference, put a dollar sign or let it blank is the same. Dollar $ for a set analysis means "for the active selections" to refer to your filters. The opposite for dollar-sign is 1 that means "disconnect your expression from all active selections", the calculations are performed on whole data.

https://help.qlik.com/en-US/sense/May2024/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalysi...

Regards.

QuestionAndAnswer
Contributor II
Contributor II
Author

That's what it seemed like to me as well. I saw no difference from taking it out or leaving it in, which further added to my confusion haha. Thanks for clarifying! 

marcus_sommer

It has nothing to do with variables else it specified the default selection state. Within the most cases there is no difference between applying the {$< and without the $-sign but there are some very specific scenarios which would return different results. I'm not sure if it's covered within the following - but even if not it's a good starting point to the use of set analysis:

Set Analysis: syntaxes, examples - Qlik Community - 1491810