topic sorting data in pivot table in QlikView

sorting data in pivot table

sushil353 — Tue, 06 Sep 2011 07:06:50 GMT

Hi All,

how do i sort data in pivot table.. i have calculated sum(total_defects) and i need to sort pivot table as per expression calculated..

Thanks

sorting data in pivot table

Tue, 06 Sep 2011 07:17:59 GMT

Try this:

go to the Sort tab.

tick the Checkbox Expression and paste ur expression here.

Choose asc or desc.

sorting data in pivot table

Sokkorn — Tue, 06 Sep 2011 10:28:14 GMT

Hi Sushil,

Right Click on Pivot table ==> Properites ==> Goto Sort tab ==> Check on check box "Expression" ==> Paste your expression sum(total_defects) in the box.

Let me know if this one help you.

Regards,

Sokkorn