topic Re: Pick Match statement as a chart expression not working in QlikView

Pick Match statement as a chart expression not working

Tue, 20 Nov 2012 09:19:40 GMT

Hi,

I've used a pick(match) statement as i wanted to avoid nested ifs, however following previous posts I cant seem to get mine to work.

vSalesExpressions- is set by an input box to one of the strings defined, I have put this expression as an expression in a line graph.

pick(Match($(vSalesExpressions),'Avg Sales','Median
Sales','Avg Winning Products','Avg Loosing Products','Top 10 Sales','Bottom 10 Sales'),

Avg(ProfitPc),

Median(ProfitPc),

Avg({1<profitindicator = {1} >}ProfitPc),

Avg({1<profitindicator = {0} >}ProfitPc),

Avg({1<SalesPerson = {"=Rank(aggr(avg(ProfitPc),
SalesPerson)) <= 10"}>}ProfitPc),

Avg({1<SalesId = {"=Rank(aggr(-avg(ProfitPc),SalesId))<=10 "}>} ProfitPc)

)

Thanks!!

Re: Pick Match statement as a chart expression not working

Anonymous — Tue, 20 Nov 2012 15:01:26 GMT

I think that the first parameter of the match() function must be string, not an expression.

Regards,

Michael

Re: Pick Match statement as a chart expression not working

swuehl — Tue, 20 Nov 2012 15:12:03 GMT

I would try enclosing your variable expansion into single quotes:

pick(Match( '$(vSalesExpressions)' ,'Avg Sales','Median...

Re: Pick Match statement as a chart expression not working

Tue, 20 Nov 2012 16:24:27 GMT

Thanks for your suggestion, however it hasnt seemed to have worked.

just to clarify vSalesExpression stores a string.

Re: Pick Match statement as a chart expression not working

Tue, 20 Nov 2012 16:24:49 GMT

Thanks for your suggestion, however it hasnt seemed to have worked.

just to clarify vSalesExpression stores a string.

Re: Pick Match statement as a chart expression not working

swuehl — Tue, 20 Nov 2012 16:43:15 GMT

Seems to work for me (using single quotes around the variable expansion). See attached.

Have you checked that your strings are not differing in trailing / leading spaces or in case?

Re: Pick Match statement as a chart expression not working

Tue, 20 Nov 2012 17:09:05 GMT

Thanks for your suggestion, however it hasnt seemed to have worked.

just to clarify vSalesExpression stores a string.

Re: Pick Match statement as a chart expression not working

Wed, 21 Nov 2012 16:32:25 GMT

Thankyou guys for all your help,

in replicating my conditions for you swuehl i found that it was nt working becuase I had a space in my strings!!!

when removing space in the string comparisons it worked. so 'avg sales' is now 'avgsales'

I'm not sure why the space posed this issue!

This then leads me to have to think of a way to make the selection box user friendly as having words with no spaces doesnt look very noce.

Re: Pick Match statement as a chart expression not working

Wed, 21 Nov 2012 17:03:50 GMT

Sorry back to the drawing bord for me, I have it working but the spaces in the stings was not the issue. Still trying to find out what the issue is>