topic Re: How to do calculated dimensional sort in QlikView

How to do calculated dimensional sort

Tue, 17 Feb 2015 11:10:24 GMT

I have a calculated dimension as said below

if(points>0, if((Last_bill_date-first_bill_date)<30,'<30',if((Last_bill_date-first_bill_date)<60,'30-60'))

I need to sort this like

<30

30-60 and on....

Can anybody please help me on the same.

Re: How to do calculated dimensional sort

sunny_talwar — Tue, 17 Feb 2015 15:50:42 GMT

Update: Try sorting by Avg(Last_bill_date-first_bill_date)

Have you tried sorting it by Last_bill_date-first_bill_date?

Best,

Re: How to do calculated dimensional sort

sunny_talwar — Tue, 17 Feb 2015 15:58:27 GMT

The idea is the when you sort by the Avg(Last_bill_date-first_bill_date), it will be in the same order as the ranges itself: so average of <30 would also be below 30 and average of 30-60 would be between those two numbers.

Hope this is what you want to do.

Best,

Re: How to do calculated dimensional sort

manojkulkarni — Thu, 19 Feb 2015 07:01:22 GMT

Calculated dimension is not necessary, then you could put this logic in load script. Sorting can be handled easily. Another part of it is , calculated dimensions will consume more time than normal fields