Lost clients

[Anonymous]

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

[shraddha_g]

Would be easier to help if you provide sample app and sample data.

[shraddha_g]

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