Solved: Sorting - Qlik Community

priyarane · ‎2015-05-15

Hi experts,

I have dimension like below

Dim1

A

B

C

D

But in my chart I wanted to show dim like below

Dim1

D

B

A

C

How to do it, can some one please help me

PrashantSangle · ‎2015-05-15

Hi,

Sort it using expression.

like match(dim1,'D','B','C','A')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2015-05-15

Hi,

Sort it using expression.

like match(dim1,'D','B','C','A')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

mohammadkhatimi · ‎2015-05-15

Hi,...

Why do u want to show in such order..??? Is there any criteria to show ???

vijetas42 · ‎2015-05-15

Hi

You can write expression in sort tab like,

if(only({1}Dim1)={'D'},11,if(only({1}Dim1)={'B'},22,if(only({1}Dim1)={'A'},33,if(only({1}Dim1)={'C'},44))))

Thanks,

Vijeta

priyarane · ‎2015-05-15

Yes, Mohammad

Sorting

Related Topics