topic Re: PIVOT chart us not able sort in QlikView

PIVOT chart us not able sort

Anonymous — Mon, 22 Jun 2015 12:09:46 GMT

Hi I have this PIVOT chart object. I am able to sort it perfectly like shown above. The AGE SLOT column is in order.

But when I do some selections - Like if I am selecting some team name then this order is getting changed as shown below.

Any specific reasons?

marcus_sommer — Mon, 22 Jun 2015 12:17:27 GMT

Have you tried it with a dual-field from [Age Slot]?

dual(string-value, numeric-value)

- Marcus

Mon, 22 Jun 2015 12:22:13 GMT

Hi Vijay,

go to Sort -> check Expression -> type

sum({1} Age)

Hope this might help

Anonymous — Mon, 22 Jun 2015 12:27:15 GMT

Hi,

Check in Sort tab, might be you have opted ascending in Numeric value.

Anonymous — Mon, 22 Jun 2015 12:33:34 GMT

Hi Marcus,

What is dual(string-value, numeric-value) and where I have to use it?

MayilVahanan — Mon, 22 Jun 2015 12:42:54 GMT

Try like this

Load *,

If(Days < 5, Dual('<5 Days', 1),

If(Days <= 10, Dual('5 to 10 Days', 2),

if(Days <= 30, Dual('11 to 30 Days', 3), Dual('>30 Days', 4))) as "Age Slot"

from datasource;

Then

In Pivot table -> Sort , use Num([Age Slot]) in Expression and Ascending.

Hope it helps