Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

Prob in expression regarding sorting

Hello ,

I have an issue.

I have a pivot table with 6 dimension and 1 expression(Duration column) as in capture1.png

Now i do sorting as per duration. I created a multibox and add Inline Table containing Duration(which is expression in pivot table) as field.

Now to sort them as per duration i just Go to Sort tab of pivot table and for each dimension i added expression.

But i don't understand why we are using aggr function (as in capture2.png) ?? and also for each next dimension i am adding previous column also in aggr fun. Why is it so ?? As a whole i cannot understand how sorting is being done by this exprssn(as in capture3.png , capture4.png)

Thanks

2 Replies
senpradip007
Specialist III
Specialist III

Based on your uploaded document it seems no uid field is there. More over could you please upload sample qvw?

nikhilgarg
Specialist II
Specialist II
Author

Hey,

I have just for example make that expression which is same as in my project. Hope this clear ur doubt