topic Re: Pivot Sorting Issue in QlikView

Pivot Sorting Issue

Wed, 22 Jul 2015 12:46:17 GMT

Hi Team,

I have 1 Dimensions and 3 Expressions in Pivot table. I want to sort by each expression.

Expressions :

sum({<Fact={'A'},date={'>=$(vFromDate)<=$(vToDate)'}>}order)

sum( {<Fact={'A'}, date={'>=$(vFromDate)<=$(vToDate)'}, category= >}total order)

sum({<Fact={'A'},date={'>=$(vFromDate)<=$(vToDate)'}>}product)

sum( {<Fact={'A'}, date={'>=$(vFromDate)<=$(vToDate)'}, category= >}total product)

sum({<Fact={'A'},date={'>=$(vFromDate)<=$(vToDate)'}>}customer)

sum( {<Fact={'A'}, date={'>=$(vFromDate)<=$(vToDate)'}, category= >}total customer)

My understanding : To create 3 buttons and align the same to each expression for sorting.

Kindly suggest me the way to carry out the same for feasible sorting of the expressions.

Thanks

Re: Pivot Sorting Issue

Kushal_Chawda — Wed, 22 Jul 2015 12:51:31 GMT

See the below link

https://community.qlik.com/docs/DOC-7220

Re: Pivot Sorting Issue

Wed, 22 Jul 2015 13:03:03 GMT

Hi Khush,

Thanks for the response. I have gone through this document and it focuses on Dimension sorting rather expressions and somehow I found the document complex to understand/implement as I am beginner for QlikView and Macro functionality.

Is there any other way you can guide me with.

Thanks