topic Lost clients in App Development

Lost clients

Anonymous — Tue, 14 Nov 2017 09:25:41 GMT

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 — Wed, 15 Nov 2017 03:42:03 GMT

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

shraddha_g — Wed, 15 Nov 2017 03:45:36 GMT

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