topic Re: Prob in expression regarding sorting in QlikView

Prob in expression regarding sorting

nikhilgarg — Tue, 10 Mar 2015 09:02:08 GMT

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

Re: Prob in expression regarding sorting

senpradip007 — Tue, 10 Mar 2015 09:06:31 GMT

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

Re: Prob in expression regarding sorting

nikhilgarg — Tue, 10 Mar 2015 09:10:03 GMT

Hey,

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