Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to create a formula for lost clienets in QlikSense but I don´t know how.
The rule is if there was no Gross Margin in the past three months the client is lost.
If have a Gross Margin column and a Date column (01/01/2017 etc.)
Can you please help me?
Best regards,
Nadine
Would be easier to help if you provide sample app and sample data.
May be like this:
l.oad
Client,
Date,
if(sum(Gross Margin) = 0,1,0) as LostFlag
From Table
where Date >= addmonths(today(),-3)
Group by Client, Date;
And then link this table to main fact table