Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
adamgaox
Creator
Creator

Sum({$<Region = {'Europe','America'}>}Value) QlikView and QlikSense

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 

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Just did it in Qlik Cloud.

2018-03-16 12_47_33-Edit Script [C__Users_Stefan_Downloads_Community_294299_2.qvw_].png

View solution in original post

11 Replies
vongalaprashant
Contributor III
Contributor III

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

swuehl
MVP
MVP

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.

adamgaox
Creator
Creator
Author

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.

adamgaox
Creator
Creator
Author

Did you try it?

swuehl
MVP
MVP

Just did it in Qlik Cloud.

2018-03-16 12_47_33-Edit Script [C__Users_Stefan_Downloads_Community_294299_2.qvw_].png

View solution in original post

jyothish8807
Master II
Master II

Hi Adam,

Can you try to change ' to " in QlikSense and try ?

Sum({$<Region = {"Europe","America"}>}Value)

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

Best Regards,
KC
adamgaox
Creator
Creator
Author

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.

adamgaox
Creator
Creator
Author

Thanks for your information Jyothish KC.

jyothish8807
Master II
Master II

Even i did not found any change

Best Regards,
KC