topic Re: Sorting on Pivot table in QlikView

Sorting on Pivot table

Tue, 11 Feb 2014 14:00:06 GMT

Hi all ,

We are trying to sort on Pivot Table for the resultant value with this Expresion:

(

Count(DISTINCT{<Users={'VIP'}>} Category)

/[Users Total]

)

But the chart show "N/A"

Please can you help us, thanks in advance.

Javi.

Re: Sorting on Pivot table

dirk_konings — Tue, 11 Feb 2014 14:23:31 GMT

Do you get the same result if you add this as an expression to your Pivot Table?

Maybe you have multiple values for [Users Total] on dimension level? Could you use min() or max() on UsersTotal?

Dirk

Re: Sorting on Pivot table

Wed, 12 Feb 2014 12:48:58 GMT

Hi Dirk, the expression is in a Pivot Table, and we have some values on dimension. But we try to sort with only one dimension and the result is the same.

Attach you captures

thanks

PD: Sorry, the QV Software is in spanish

Re: Sorting on Pivot table

dirk_konings — Fri, 14 Feb 2014 07:25:23 GMT

it says : Garbage after Num#. Is there something else in this expression?

Do the other 3 expression give a result if you deactivate this one?

Please attach a printscreen of your dimensions.

Dirk

Re: Sorting on Pivot table

Mon, 17 Feb 2014 13:12:44 GMT

Thanks Dirk, we are using Num# to convert a value. Now is removed in the expression and the sorting is right.

Regards!!