topic Sort on expression in pivot table (Urgent) in QlikView

Sort on expression in pivot table (Urgent)

Mon, 10 Mar 2014 04:13:12 GMT

Hi,

I have one requirement like, user should be able to sort on expression in pivot table.Interactive sort option is not available in pivot table.

But is it possible to sort in pivot table on expression??

Can we use any expression to sort on expression like there will be sort options for user Asxending or descending,and depeding on the option user will choose, it will sort on that expression in pivot table..

Thanks in Advance...!!!

Re: Sort on expression in pivot table (Urgent)

SunilChauhan — Mon, 10 Mar 2014 04:20:06 GMT

right click on object

select

properties-> sort-> Expression->

type your expression make it ascending or descending as per need.

hope this helps

Re: Sort on expression in pivot table (Urgent)

Mon, 10 Mar 2014 05:57:25 GMT

Expression means any QlikView expression which will take input from the user and will sort accordingly either ascending or descending.

Re: Sort on expression in pivot table (Urgent)

its_anandrjs — Mon, 10 Mar 2014 06:22:38 GMT

Hi,

Yes make a inline table for option and on application give option for selection of ascending or descending and check this value of selection in the sort -> Expression with any if option and give two condition there for as ascending or descending.

Hope this helps

Thanks & Regards

Re: Sort on expression in pivot table (Urgent)

its_anandrjs — Mon, 10 Mar 2014 06:36:16 GMT

Hi,

Another option is make two charts one expression by ascending and second by descending sort and enable or disable this charts by any selection then you get two options. Whenever you select any option like you select ascending then deselect the descending chart that time like ways another one.

Hope this helps

Thanks & Regards

Re: Sort on expression in pivot table (Urgent)

Mon, 10 Mar 2014 06:37:54 GMT

I have attached the screen shot for the same. I have 2 dimensions address and city and 2 expressions Sales and sales growth in pivot table.

I want to sort descending on Sales expresions.But in sort properties it shows only dimensions and not expressions as it is pivot table.

So Is it possible to sort on expressions in pivot table??

Re: Sort on expression in pivot table (Urgent)

its_anandrjs — Mon, 10 Mar 2014 06:44:11 GMT

Hi,

Yes it is possible go to sort option of the chart and in Sort by section select Expression there below a text box is available then paste your option there like Sum(Sales) and select ascending or descending option from drop down menu.

Hope this helps

Thanks & Regards

Re: Sort on expression in pivot table (Urgent)

sunilkumarqv — Mon, 10 Mar 2014 07:09:36 GMT

Hi priya,

Its possible these on script level change you table values accordingly show data what you want and sort the data

Re: Sort on expression in pivot table (Urgent)

Mon, 10 Mar 2014 07:32:06 GMT

Hi,

I have written sum(Sales) expression in sort properties.

Find the dummy data excel for reference.

In pivot table there are 2 products by which we are displaying sales.

If I wrote the sum(sales ) expression in sort and only 1 product is selected it shows the right output i.e sort the expression in descending.

But if there are 2 products, then it does not shows the consistent data as for the 2nd prouct sometimes sales might be more.