Union Query

[PD]

Hi Qlik People,

I am trying to do the following.Skeleton of my SQL query as below

Select

var1,var2,M,'Q1' as identifier from table

Union

Select

var1,var2, M,'Q2'  as identifier from table

Union

Select

var1,var2,M,'Q3' as identifier from table

I am pulling this data in my dashboard in QVD and trying to build separate measures using the identifiers

Example: measure1=sum({<identifier={'Q1'}>}M)

But the data is not coming correctly , can you please advice

[JordyWegman]

Hi PD,

Can you show a part of you data? Then it's easier to comment on this.

Jordy

Climber