Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sushil353
Honored Contributor II

sorting data in pivot table

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

2 Replies
Not applicable

sorting data in pivot table

Try this:

go to the Sort tab.

tick the Checkbox Expression and paste ur expression here.

Choose asc or desc.

Sokkorn
Honored Contributor

sorting data in pivot table

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

Community Browser