topic % in pivot table in App Development

% in pivot table

Anonymous — Thu, 19 Oct 2017 11:12:26 GMT

Hi everyone,

I long time didnt work with Qlik, so I forgot many knowledge about it. Maybe I ask for something easy, but for me is now really hard.

I made pivot table. In row I have weeks (week 01, week 02 etc.). In column I have count material in different areas. It is area A, area B and area C. Throught Filter pane I set filter to see only count of material with Movement 1 (I have few different movements and I need see only movement 1) . And now I have in pivot table almost all numbers that I need, but I need add how many % count materials in each area it is and I dont know how.

Most sympliest result is convert it to Pie chart, then in Pie chart I see % that I need. But I need see % in column inside my pivot table.

Please can anyone help me?

Thank you.

Re: % in pivot table

sunny_talwar — Thu, 19 Oct 2017 11:19:18 GMT

May be you need one of these

Count(Material)/Count(TOTAL Material)

Count(Material)/Count(TOTAL <Area> Material)

Count(Material)/Count(TOTAL <Week> Material)

Re: % in pivot table

Anonymous — Thu, 19 Oct 2017 11:31:41 GMT

Thank you Sunny. You have right. I forgot at function "Total". 🙂 I tried something with set analyse and $ a 1. And it was nonsense.