topic Re: Sorting in QlikView

Sorting

priyarane — Fri, 15 May 2015 07:32:57 GMT

Hi experts,

I have dimension like below

Dim1

But in my chart I wanted to show dim like below

Dim1

How to do it, can some one please help me

PrashantSangle — Fri, 15 May 2015 07:36:17 GMT

Hi,

Sort it using expression.

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

Regards

mohammadkhatimi — Fri, 15 May 2015 07:37:42 GMT

Hi,...

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

vijetas42 — Fri, 15 May 2015 07:43:49 GMT

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 — Fri, 15 May 2015 07:49:59 GMT

Yes, Mohammad