topic Re: Problem using pick function in QlikView

Problem using pick function

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I tried to use the below said expression using the Synthetic Dimension (%Dual) instead of value list

pick(%Dual,count(DISTINCT {< ForActiveCustomerMonth=, ForActiveCustomerMonthYear=, ForActiveCustomerYear=, MonthEndDate=>}

if(aggr(vInputDate-max(CustMaxDate)>=0 and vInputDate-max(CustMaxDate)<=365,user_id_A, MonthEndDate),user_id_A)),

count(DISTINCT {< ForActiveCustomerMonth=, ForActiveCustomerMonthYear=, ForActiveCustomerYear=, MonthEndDate=>}

if(aggr(vInputDate1-max(CustMaxDate)>=0 and vInputDate1-max(CustMaxDate)<=365,user_id_A, MonthEndDate),user_id_A)))

Variable InputDate = Monthend Date provided by the client in 'YYYY-MM-DD' format (eg. 2016-03-31)

Variable InputDate1 = Previous monthend date for the client provided (eg. 2016-02-29)

But, am finding that, the first expression works, but the second expression is not working in the table.

I cross-checked the same individually using text object & both the expressions are working fine.

Can anyone help me out on this issue.

Thanks in advance,

Regards,

Anand B Nagaraj

Re: Problem using pick function

Gysbert_Wassenaar — Mon, 06 Jun 2016 16:47:48 GMT

Please post a small qlikview document that demonstrates the problem.

Re: Problem using pick function

sunny_talwar — Mon, 06 Jun 2016 17:19:27 GMT

What about this may be?

Count(DISTINCT {< ForActiveCustomerMonth=, ForActiveCustomerMonthYear=, ForActiveCustomerYear=, MonthEndDate=>} If(Aggr(NODISTINCT vInputDate1-max(CustMaxDate)>=0 and vInputDate1-max(CustMaxDate)<=365, user_id_A, MonthEndDate), user_id_A)))

Re: Problem using pick function

Anonymous — Thu, 06 Oct 2016 13:53:22 GMT

Hi ,

can I use pick /match function for the below

if(PG='MS' or PG='P others'or PG='NLE' or PG='PECE' or PG='HCE',dual('Others',26),

if(PG='CPS',dual('CPS',12),if(PG='PCS',dual('PCS',10),if(PG='PSSEU',dual('PSSEU',13),if(PG='ALL'or PG='',null(),PG))))) as Prod_Group

Re: Problem using pick function

Peter_Cammaert — Thu, 06 Oct 2016 15:47:16 GMT

Yes you can. But an applymap() would be even better, I think.

Re: Problem using pick function

Anonymous — Fri, 07 Oct 2016 12:34:34 GMT

Hi ,

can I use pick /match function for the below

if(PG='MS' or PG='P others'or PG='NLE' or PG='PECE' or PG='HCE',dual('Others',26),

if(PG='CPS',dual('CPS',12),if(PG='PCS',dual('PCS',10),if(PG='PSSEU',dual('PSSEU',13),if(PG='ALL'or PG='',null(),PG))))) as Prod_Group

Re: Problem using pick function

Anonymous — Fri, 07 Oct 2016 13:22:22 GMT

Hi Peter,

Can u share your idea how can u write applymap() there?

Regards

pavan

Re: Problem using pick function

rupamjyotidas — Fri, 07 Oct 2016 13:56:15 GMT

Use something like this

if(WildMatch(PG,'MS','*others*','NLE','PECE','HCE')>0,Dual('Others',26),....) as Prod_Group

Note: Equation is not complete

Re: Problem using pick function

dunnalahk123 — Mon, 24 Sep 2018 07:46:58 GMT

Hi Sunny,

I have a question regarding pick function.

when i selection one of my dimension pick function is not working as expected, could you help me with that.

Re: Problem using pick function

sunny_talwar — Sat, 29 Sep 2018 15:25:43 GMT

Where are you using your expression and what is the expression?