topic Re: Sorting a Pick Match Dimension in QlikView

Sorting a Pick Match Dimension

Sun, 04 Nov 2012 02:38:32 GMT

I have a chart with dimension as Pick(Match(KPI,1,2,3),ActivitiesDesc,'Perf vs Plan','% of NetSales')

and few expressions as Pick(Match(KPI,1,2,3),Sum(Sales),expr for PerfvsPlan,expr for % of Net Sales)

Here ActivitiesDesc is a FieldName

I want to sort my dimension in the chart as

ValueofActivitiesDesc,

'Perf vs Plan',

Value of ActivitiesDesc,

'% of Net Sales'

pls suggest

Re: Sorting a Pick Match Dimension

SunilChauhan — Sun, 04 Nov 2012 06:02:11 GMT

you can sort either using one dimension or one expression

hope this helps

Re: Sorting a Pick Match Dimension

Sun, 04 Nov 2012 12:32:21 GMT

I have only one dimension i want to sort the dimension as i mentioned

Re: Sorting a Pick Match Dimension

whiteline — Sun, 04 Nov 2012 16:04:06 GMT

Hi.

If I understand you right, the problem is with sorting field values and strings simultaneously.

You could try to adopt this trick for dimension:

=Pick(Match(KPI,1,2,3),

dual(text(ActivitiesDesc), fieldIndex('ActivitiesDesc', ActivitiesDesc)),

dual('Perf vs Plan', 0),

dual('% of NetSales', 100000))

Then just use sort by numeric value.

Re: Sorting a Pick Match Dimension

Mon, 05 Nov 2012 01:30:16 GMT

Hey whiteline nice Superb! i got it exactly how i want but for the text (means Perf vs Plan and % of net Sales) i have to give different color can u help me in solving this

Re: Sorting a Pick Match Dimension

whiteline — Mon, 05 Nov 2012 07:13:07 GMT

If you expand the plus sign to the left of your expression or dimension, you'll see Background Color and Text Color. There you can write an expression to colorize the cells.

For example, to assign different colors for 'text' and ActivitiesDesc you can use:

=if(Match(KPI,1,2,3)=1, blue(), green())

Re: Sorting a Pick Match Dimension

Mon, 05 Nov 2012 08:54:50 GMT

Thanks a lot