topic Re: Using Desc/Asc in Expressions in QlikView

Using Desc/Asc in Expressions

Tue, 22 Apr 2014 11:36:43 GMT

Hello everyone,

I got a lot of help with my other discussion so thank you for the support, but here I am with another question. Sorry if I open a lot of discussions but I am very new with QlickView.

I added an Expressions to a new SheetObject from Chart Pivot Table. I added the SUM but I want to use ASCENDING/DESCENDING on it but I cannot seem to find nor how to do it. I want higher values to be on top, lower values to be on bottom.

Thanks in advance.

Re: Using Desc/Asc in Expressions

bumin — Tue, 22 Apr 2014 11:38:45 GMT

you have to go to the sort page and define sort oder there

Re: Using Desc/Asc in Expressions

its_anandrjs — Tue, 22 Apr 2014 11:40:50 GMT

Update check now

Go to chart properties >> Sort >> Expression and paste your expression there and select descending

See snap

Re: Using Desc/Asc in Expressions

Tue, 22 Apr 2014 11:41:10 GMT

The thing is I don't see the NETCIKISTUT there. Do I need to add that field and use the sort from there? will it effect the SUM(NETCIKISTUT) ?

Re: Using Desc/Asc in Expressions

MK_QSL — Tue, 22 Apr 2014 11:41:37 GMT

There are some restriction in PIVOT Table Sorting..You can only do sorting on One Dimension ..... at a time.. better to use straight table

Re: Using Desc/Asc in Expressions

its_anandrjs — Tue, 22 Apr 2014 11:46:25 GMT

You can sort on the basis of the Dimension but based on expression you can sort the table for this go to

Chart properties >> Sort >> Un check all >> tick on expression >> and paste there your expression Sum(NETCIKISTUT) and select descending.

Hope this helps

Re: Using Desc/Asc in Expressions

Tue, 22 Apr 2014 12:02:18 GMT

Updated:

Thank you all for the help. I got it figured out