topic Re: Pick Function in QlikView

Pick Function

Mahamed_Qlik — Wed, 24 Feb 2016 08:38:50 GMT

How can we use the calculated dimensions in pick(match) fucntion?

Regards,

Mahamed

Re: Pick Function

tamilarasu — Wed, 24 Feb 2016 08:45:37 GMT

Check the below link.

Add Calculated Dimensions

Re: Pick Function

mightyqlikers — Wed, 24 Feb 2016 08:54:45 GMT

HI,

pick(match(MONTHFIELD,'JAN','FEB','MAR','APR','MAY'),1,2,3,4,5)

Regards
$@M.

Re: Pick Function

Mahamed_Qlik — Wed, 24 Feb 2016 09:00:44 GMT

What if

I have cycliv group name as Group1

Group1 has dimensions like Month, Year,

But Month is calculated then? (if(isnull(Month),'Unknown',Month)

Pick(Match(Group1),'Month','Year'),'1','2')

It works fine for Year not for Month

Re: Pick Function

amayuresh — Thu, 10 Mar 2016 10:54:01 GMT

You may use Pick(Match()) to get quarter as,

=PICK(MATCH(Order_Month,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),'Q1','Q1','Q1','Q2','Q2','Q2','Q3','Q3','Q3','Q4','Q4','Q4')

Re: Pick Function

Mahamed_Qlik — Thu, 10 Mar 2016 12:48:21 GMT

Thank you mayuresh.

Issue has been already resolved.

Re: Pick Function

Chanty4u — Thu, 10 Mar 2016 12:50:09 GMT

nice. Please close the thread if u get the solution by making correct and helpful answers