Pick Function

[Mahamed_Qlik]

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

Regards,

Mahamed

[tamilarasu]

Check the below link.

Add Calculated Dimensions

[mightyqlikers]

HI,

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

Regards
$@M.

[Mahamed_Qlik]

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

[amayuresh]

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')

[Mahamed_Qlik]

Thank you mayuresh.

Issue has been already resolved.

[Chanty4u]

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