Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Anyone notice the expression Sum({$<Region = {'Europe','America'}>}Value) differences between QlikView and QlikSense?
In QlikView no matter what selection make in the Region the result will always calculate Europe and Amercia two regions value but in QlikSense the selection make outside will impact the result for example I select Europe and QlikSense will only calculate Europe value.
If I understand it correctly?
Thanks in advance
Just did it in Qlik Cloud.
Hi Adam,
When you are declaring Region=europe and America then set analysis will always calculate sum(value) only for both the countries.
leaving other countries.
I guess it is same in both the qlik's.
regards,
prashanthi.v
Are you asking if there is a difference or have you actually experienced a difference between QlikView and QlikSense?
If latter, please post a small sample APP that demonstrates it.
Hi Stefan,
I actually do both chart in qlikview and qlik sense.
You can try to create inline table with two fields
Country , Value
including two rows
Then create bar chart using the same expression and make selections in both QV and QS.
I was just wandering if you also got the same result that they are different.
Did you try it?
Just did it in Qlik Cloud.
Hi Adam,
Can you try to change ' to " in QlikSense and try ?
In the recent QS release i have seen these kind of behavior. QS is now very particular with String search and numeric search.
BR,
KC
Hi Stefan,
I think you're right. I just notice I make a stupid mistake,I just put the $ sign outside the bracket
Sum(${<REGION = {'Europe','America'}>}VALUE).
Thanks a lot for your help.
Thanks for your information Jyothish KC.
Even i did not found any change