Static Headers in Pivot Table

[Ivak]

Hello All,

I have input like below:

C#	Location	Mrkt	value
C1	Loc1	US	1
C1	Loc2	US	2
C2	Loc1	US	5
C2	Loc2	US	6
C2	Loc3	US	1

Trying to visualize above data (Location, Market, value) in Pivot table, C# in filter pane.
If user select 'C1' data from 'C#' from filter pane, I am expecting output like below:

Mrkt	Loc1	Loc2	Loc3
USA	1	2	0

Headers should be static.
In Pivot:
Dimension as 'Mrkt'
Column as 'Location'
Measure as Sum(value).

I tried multiple approach like loading separate inline table for Location values with this expression Sum({<Location={'Loc1','Loc2','Loc3'}>}value), but not works.

Thank you in advance for your solutions.


Qlik Sense Enterprise on Windows 

[MatheusC · Accepted solution]

Hi @Ivak 
This should return a value of zero to you, which in your example would be Loc3.

Sum(value) + sum({1} 0)


- Matheus

[Ivak]

Thankyou @MatheusC , Its working!!