Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Pivot Table Doubt

Hi Friends,

I have below data, which i am trying to project it in Pivot table but not able to display process name having no values in particular week.

How can we achieve this ?

   

ProcessDateCount
P101-05-201710
P201-05-201714
P302-05-201720
P403-05-201780
P508-05-2017100
P108-05-201710
P208-05-201714
P308-05-201720

Expected Output in Pivot

 

ProcessWk1Count
P11-510
P21-514
P31-520
P41-580
P51-50
4 Replies
Highlighted

Re: Pivot Table Doubt

Why is P5 = 0?

Highlighted
Partner
Partner

Re: Pivot Table Doubt

P5 doesn't have value in week1 but still need to show all the Process irrespective of data availibility

Highlighted
Specialist II
Specialist II

Re: Pivot Table Doubt

One way of working it out is that add 1 as an additional expression and then hide that column

Pivot Column Width to Zero

Highlighted
Partner
Partner

Re: Pivot Table Doubt

Thanks for your reply. I tried this with Macro but when we export the data hidden column will appear.

Do we have any other way to do this ?