Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vkish16161
Creator III
Creator III

Toggle between Filterpane/Expression dimensions using Pick/ Match

All,

I have a question.

We have a Value_Selector field in the DM with these 3 values 'A','B','C'.

We also have 3 separate flags in the DM named 'A','B','C'. The values for these flags are 0 and 1 only.

We have an expression of the form

Sum(Sales * if(Value_Selector='A',,

                       if(Value_Selector='B',,

                           if(Value_Selector='C',, ))))



Can I use a Pick/Match for this?


BIG Caveat: What if the user selects multiple values. (Like A and B or All of them)

cleveranjosswuehl

1 Solution

Accepted Solutions
sunny_talwar

How about this?

Sum(Sales * $(=If(GetSelectedCount([Area Universe]) = 1, '[' & [Area Universe] & ' Flag]', '[AC Flag]')))

View solution in original post

3 Replies
vkish16161
Creator III
Creator III
Author

ALL, just an update.

I used this and it looks like it works, but only in a filterpane. I still can't get the expression to work properly.

(pick

(Alt(match([Area Universe],'DSP','PC','AC'),'4'),[DSP Flag],[PC Flag],[AC Flag],[AC Flag])

)


P.S for the caveat - I have simply used the Alt function.

sunny_talwar

How about this?

Sum(Sales * $(=If(GetSelectedCount([Area Universe]) = 1, '[' & [Area Universe] & ' Flag]', '[AC Flag]')))

vkish16161
Creator III
Creator III
Author

Good solution as usual Sunny. Will try this out.

Thanks for the help.