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: 
priyarane
Specialist
Specialist

set and pick

Hi Community,

Can you please advise on below

1. Pick(match(vTest,'EAD','RWA','Pick1','Pick2')

so here I am looking like if(vTest='EAD', 'Pick1',if(vTest='EAD','Pick2') - how can I do with Pick

2. Sum(EAD)  where Dim1 ='A' , Dim1='B'

so Can I go like Sum({<Dim1 = {'A','B'}>}EAD) or Sum({<Dim1 *= {'A','B'}>}EAD)

1 Solution

Accepted Solutions
4 Replies
sunny_talwar

You just need a extra parenthesis for the 1st one, I believe:

Pick(Match(vTest,'EAD','RWA'),'Pick1','Pick2')

For the second one, it seems both the expression will work the same without selection, will have different reaction to selection in Dim1.

Sum({<Dim1 = {'A','B'}>}EAD) -> Won't change with selection in Dim1

Sum({<Dim1 *= {'A','B'}>}EAD) - > Will show intersection of your selection and Dim1 = A, B. So if you have not selected A or B in your selection, you won't see anything with this expression.

HTH

Best,

Sunny

sunny_talwar

Capture.PNG

jonathandienst
Partner - Champion III
Partner - Champion III

1.  =Pick(match(vTest,'EAD','RWA'),'Pick1','Pick2')    // note the closing parenthesis

2.  =Sum({<Dim1 = {'A','B'}>} EAD)      // didn't you try this?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rubenmarin

Also being moderated: