Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Variable left side of Set Modifier in Set Analysis

Dear Community,

i want to make the left side of the set modifier inside a set analysis variable.

For that i use a simple List of possible dimensions names & and a variable that catches the current field selection.


I want to use the list as follows:


SUM({1<$(LIST)=P()>} KPI)


So inside the dimension list if i select DIM_A

the set analysis should use SUM({1<DIM_A=P()>} KPI)


This is not working

What do i wrong?


12 Replies
Anonymous
Not applicable
Author

Thanks for the massive participation in this case!

Using it directly from the field : Sum({1<$(=LIST) = P()>} KPI)

OR

Using it with an variable : Sum({1<$(vListVal) = P()>} KPI)

both work great in QlikView BUT when trying this solutions in QlikSense it seems not to work

sunny_talwar

Seems to be working here

Capture.PNG

Anonymous
Not applicable
Author

Yes you are right, i had a problem with my QlikSense APP.

Thanks!