Alternate States Query - QlikSense

[yadavprachi02]

Hello dear members,

While creating a pivot table, dimension values are getting restricted by measure which is in default state. I need to show the dimension values if measure 1 and measure 2 has values in it

Pivot Table (Not showing all dimension values):

Dim1	Measure1 (Default State)	Measure2 (Alternate State)
A	100	12
B	200	-
C	300	14

Data: 

Dimension	Measure1	Measure2
A	100	12
B	200	-
C	300	14
D		15

Expected Pivot Table:

Dimension	Measure1	Measure2
A	100	12
B	200	-
C	300	14
D	-	15

How can we include the dimension value that does not have data in default state measure but do have data in Alternate state measure?

Do let me know if any other details are needed

Thanks in Advance!

Thanks,

Prachi

[hoangvvo]

not sure if it will work but

alt(measure1,0) 

then ensure that pivot table's additional data  is turn on for showign 0 metric

[Anil_Babu_Samineni]

@yadavprachi02 You have not mentioned the Alternate state information for what you have applied.