topic Re: Re: help with sorting in Pivot table in QlikView

help with sorting in Pivot table

Anonymous — Thu, 17 Apr 2014 16:09:32 GMT

Hi i have pivot table in which i have Item Type Desc, sport & Style and Name...with expressions shown below in the qvw document. All i want is sort on Style Dimension with the following expression if total Bgt margin % is less than 2014 ACT margin % then arrange those Styles in ascending order and if total Bgt margin % is greater than 2014 ACT margin % then arrange those Styles in ascending order. Please see the qvw document and as well as attached is the screen shot how it should look like....

Re: help with sorting in Pivot table

rustyfishbones — Thu, 17 Apr 2014 16:11:17 GMT

Access is denied to the Document it fails to load

Regards

Alan

Re: help with sorting in Pivot table

Anonymous — Thu, 17 Apr 2014 17:24:34 GMT

sorry let me remove the section access and put it back...

Re: Re: help with sorting in Pivot table

Anonymous — Thu, 17 Apr 2014 17:49:41 GMT

attached is the application without section access..

Re: Re: help with sorting in Pivot table

Anonymous — Thu, 17 Apr 2014 17:50:25 GMT

Alan, Thanks for your help in advance

Re: Re: help with sorting in Pivot table

Anonymous — Thu, 17 Apr 2014 19:06:09 GMT

any help on this

Re: Re: help with sorting in Pivot table

rustyfishbones — Fri, 18 Apr 2014 08:02:49 GMT

Hi Vinay,

You can add

IF($(temp) > $(BB_ACT_Margin%),$(temp))

to Style Dimension in the Sort Tab >> Expression

Does that help?

Re: help with sorting in Pivot table

Anonymous — Fri, 18 Apr 2014 13:27:10 GMT

Hi Alan, thanks for your reply let me try that and get back to you ....

Re: help with sorting in Pivot table

rustyfishbones — Fri, 18 Apr 2014 13:52:46 GMT

Re: help with sorting in Pivot table

Anonymous — Fri, 18 Apr 2014 13:58:20 GMT

I helped me little bit ,,, but did not do the job... Sport dimension is messing up everything there....