Union Query

PD — Fri, 17 May 2019 11:27:21 GMT

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

Re: Union Query

JordyWegman — Fri, 17 May 2019 13:36:05 GMT

Hi PD,

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

Jordy

Climber