Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
KarlaDS
Contributor
Contributor

Pivot table with calculated dimension

Hi everyone

I have a problem...i have this information:

data.JPG

 

And i want to use a pivote table to show the categories that contain a Description with "Undefined" value. But i also need to show the rest of the descriptions, not only "Undefined". I only can get this:

result.JPG

But I need to get this:

result2.JPG

This is the data:

LOAD * inline [
Category,Description,Date
A,Undefined,01-01-2020
B,Juice,01-05-2020
B,Juice,01-07-2020
C,Butter,01-08-2020
A,Grapes,03-05-2020
A,Grapes,06-05-2020
C,Undefined,06-05-2020
C,Butter,03-03-2020
]
;

 

I hope someone can help me to figure out this problem.

 

Thanks!

2 Replies
lironbaram
Partner
Partner

hi 

using category as first dimension and description as second dimension 

use this expression in the pivot table 

Count({<Category=p({1<Description={"Undefined"}>}Category)>} Date)
KarlaDS
Contributor
Contributor

This is not working, with your code i'm getting this:

1.JPG

 

And this is the result that i need:

2.JPG