Skip to main content
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!