Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
Pedro_Rodriguez
New Contributor III

Show all dimensions in pivot table, filter sensitive

Hi all,

I have this example of data:

Table:
Load * inline
[
Month,Quarter,Data
1,Q1,111
1,Q3,11
2,Q2,2123
2,Q3,21
3,Q3,322
8,Q8,33
9,Q9,
10,Q10,
];

I want a pivot table as in the attached file showing all dimension values including those where Data is null.

Besides I want the table to be filter sensitive, so the solution of including a Dual+Dummy field in the expression is not feasible.

Please find this example attached.

 

Thanks a lot in advance.

Labels (3)
1 Solution

Accepted Solutions

Re: Show all dimensions in pivot table, filter sensitive

This?

image.png

1 Reply

Re: Show all dimensions in pivot table, filter sensitive

This?

image.png

Community Browser