topic Re: Pivot table with calculated dimension in QlikView

Pivot table with calculated dimension

KarlaDS — Tue, 11 Aug 2020 16:56:59 GMT

Hi everyone

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

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:

But I need to get this:

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!

Re: Pivot table with calculated dimension

lironbaram — Tue, 11 Aug 2020 18:10:16 GMT

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)

Re: Pivot table with calculated dimension

KarlaDS — Wed, 12 Aug 2020 21:56:59 GMT

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

And this is the result that i need: