Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting a Pick Match Dimension

Hi

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

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

6 Replies
SunilChauhan
Champion
Champion

you can sort either using one dimension or one expression

hope this helps

Sunil Chauhan
Not applicable
Author

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

whiteline
Master II
Master II

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.

Not applicable
Author

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

whiteline
Master II
Master II

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

Not applicable
Author

Thanks a lot