Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

vinay_bangari
Valued Contributor III

help with sorting in Pivot table

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....

9 Replies
rustyfishbones
Honored Contributor II

Re: help with sorting in Pivot table

Access is denied to the Document it fails to load

Regards

Alan

vinay_bangari
Valued Contributor III

Re: help with sorting in Pivot table

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

vinay_bangari
Valued Contributor III

Re: Re: help with sorting in Pivot table

attached is the application without section access..

vinay_bangari
Valued Contributor III

Re: Re: help with sorting in Pivot table

Alan, Thanks for your help in advance

Highlighted
vinay_bangari
Valued Contributor III

Re: Re: help with sorting in Pivot table

any help on this

rustyfishbones
Honored Contributor II

Re: Re: help with sorting in Pivot table

Hi Vinay,

You can add

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

to Style Dimension in the Sort Tab >> Expression

Does that help?

2014-04-18_0901.png

vinay_bangari
Valued Contributor III

Re: help with sorting in Pivot table

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

rustyfishbones
Honored Contributor II

Re: help with sorting in Pivot table

ok

vinay_bangari
Valued Contributor III

Re: help with sorting in Pivot table

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

Community Browser