Set Analysis not working in Qliksense

[krishna20]

Hi Folks,

My set analysis expression is not working in Qliksense. I don't know where i'm going wrong. Please find the attached sample app and guide me.

[igdrazil · Accepted solution]

You were missing some signs :

(Sum({<Category_ID={'Cat_001'},YEAR={'$(=$(vCurrentYear))'}>}Value))

I also updated your .qvf!

See attached File

Regards

Chris

[krishna20]

Hi Christ,

Thank you very much for prompt reply.

This expression is working in Qlikview but not in Qliksense. Please clear my confusion.

(Sum({<Category_ID={'Cat_001'},YEAR={$(=vCurrentYear)}>}Value))

[igdrazil]

So i opened your .qvf file in Qlik Sense and updated your Expression, so it is working in Qlik Sense. Why shouldn't it work for your then?

Did u check my .qvf that i attached?

Afaik there are no Measure Expressions that are working in QV but not in QS.

Regards

Chris

[krishna20]

No Christ, My Question is

Difference between these two expressions..

1. your's ::::  (Sum({<Category_ID={'Cat_001'},YEAR={'$(=$(vCurrentYear))'}>}Value))

2. Mine ::::  (Sum({<Category_ID={'Cat_001'},YEAR={$(=vCurrentYear)}>}Value))

My expression is working in QV but not in QS. Why and what may be reason??

The variable stores max year only.

[igdrazil]

To use a Variable in there you have to put them in Single Quotation Marks and then use the $() - function to get the Value of that specific Variable.

I'm not sure why but i know that it's needed, sorry =(

Regards

Chris

[krishna20]

Thank you christ for your time and explanation ...

[brunobertels]

Hi

Here the différence between the 2 expressions :

1. your's ::::  (Sum({<Category_ID={'Cat_001'},YEAR={ ' $(=$(vCurrentYear)) ' }>}Value))

(see he single quotes for second modifier Year = { single quote '$(=$(vCurrentYear)) single quote ' }>}Value))

2. Mine ::::  (Sum({<Category_ID={'Cat_001'},YEAR={$(=vCurrentYear)}>}Value))

Bruno