Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Question regarding set analysis

Hello,

I'm very new to set analysis and have a quick question.

I was wondering what is the difference between '1' and '$' when set modifier are given as identical.

for example:

Sum({1<Year={'2013'}>}Sales)

Sum({$<Year={'2013'}>}Sales)

Based on my test, above returns the same results.

If both gives the same result, in which case do i need to use 'Sum({1<Year={'2013'}>}Sales)' rather than 'Sum({$<Year={'2013'}>}Sales)' ?

Thanks.

Tags (1)
1 Solution

Accepted Solutions

Re: Question regarding set analysis

Difference between $ and 1 will be visible once you will make selections. With  1 in your expression, any selection made won't change the result of the expression, but $ will filter out the selections and give you the results for only those elemets selected by the user. For more details on set analysis, you might want to check out the attached file.

4 Replies

Re: Question regarding set analysis

Difference between $ and 1 will be visible once you will make selections. With  1 in your expression, any selection made won't change the result of the expression, but $ will filter out the selections and give you the results for only those elemets selected by the user. For more details on set analysis, you might want to check out the attached file.

balrajahlawat
Esteemed Contributor

Re: Question regarding set analysis

amit_saini
Honored Contributor III

Re: Question regarding set analysis

Hi,

Thanks,

AS

Not applicable

Re: Question regarding set analysis

Thanks for kind reply.

Community Browser