Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You were missing some signs :
(Sum({<Category_ID={'Cat_001'},YEAR={'$(=$(vCurrentYear))'}>}Value))
I also updated your .qvf!
See attached File
Regards
Chris
You were missing some signs :
(Sum({<Category_ID={'Cat_001'},YEAR={'$(=$(vCurrentYear))'}>}Value))
I also updated your .qvf!
See attached File
Regards
Chris
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))
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
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.
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
Thank you christ for your time and explanation ...
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