topic Re: set and pick in QlikView

set and pick

priyarane — Thu, 08 Oct 2015 12:35:18 GMT

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)

Re: set and pick

sunny_talwar — Thu, 08 Oct 2015 13:07:38 GMT

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

Re: set and pick

sunny_talwar — Thu, 08 Oct 2015 13:11:50 GMT

Re: set and pick

jonathandienst — Thu, 08 Oct 2015 13:13:45 GMT

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

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

Re: set and pick

rubenmarin — Thu, 08 Oct 2015 13:18:00 GMT

Also being moderated: