Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

n_schmersahl
New Contributor

Lost clients

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

2 Replies
shraddha_g
Honored Contributor III

Re: Lost clients

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

shraddha_g
Honored Contributor III

Re: Lost clients

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

Community Browser