Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
manojkulkarni
Partner - Specialist II
Partner - Specialist II

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
sunny_talwar

Why is P5 = 0?

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

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

neelamsaroha157
Specialist II
Specialist II

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

Pivot Column Width to Zero

manojkulkarni
Partner - Specialist II
Partner - Specialist II
Author

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 ?