Pivot Sorting Issue

[#1]

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

[Kushal_Chawda]

See the below link

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

[#3]

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