Skip to main content
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combine flags from different tables as a union


I've built a set expression in a straight table that combines the results of two flags in the script.

If(Customer='A',Y,N) as CusFlag

From CustomerTable;


If(count(CustomerSales>3,Y,N) as CountFlag

From FactTable;

I know the syntax is simplified but hope you get the idea.

Now I'd like two combine those two flags in the script so that I don't have to build a union expression in set analysis. I'd like to have

a flag that says:

FlagTotal Yes/No in the application where Yes combines the results of CusFlag and CountFlag.

0 Replies