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?
Would be easier to help if you provide sample app and sample data.
May be like this:
if(sum(Gross Margin) = 0,1,0) as LostFlag
where Date >= addmonths(today(),-3)
Group by Client, Date;
And then link this table to main fact table
Retrieving data ...