Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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
Highlighted

1 Reply
Highlighted