Alternate States Query - QlikSense

yadavprachi02 — Wed, 07 Feb 2024 17:31:14 GMT

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

Re: Alternate States Query - QlikSense

hoangvvo — Wed, 07 Feb 2024 17:40:31 GMT

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

Re: Alternate States Query - QlikSense

Anil_Babu_Samineni — Wed, 07 Feb 2024 20:18:49 GMT

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

topic Re: Alternate States Query - QlikSense in App Development

Alternate States Query - QlikSense

Re: Alternate States Query - QlikSense

Re: Alternate States Query - QlikSense