Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

show all row in pivot table even if other dimension is limited

hi,

i try to do something

i have data depends on 2 dimensions

Taskmonthdata
Task110
Task310
Task120
Task220
Task130
Task230
Task140
Task211
Task321
Task331
Task241
Task341

first case, i try to show all tasks for each month in pivot table even if datas for task1 is null for each month.

this case is my first pivot table

second case, i try to limit number of month shown but i would like see all tasks too.

this case is my second pivot table

2 Replies
Not applicable
Author

Hi,

Hope this helps

Regards!

Not applicable
Author

Thx Gabriela!!

i was checked "delete null value" 😕