Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi PD,
Can you show a part of you data? Then it's easier to comment on this.
Jordy
Climber