Need help on count the customers in straight table

[Anonymous]

Hi Experts,

Need to count the active customers in straight table.

Active customer:

Active Customers are who made sale twice in the last three months.

how to write expression for this??  Help is much appreciated.

Regards,

Raju

[Kushal_Chawda]

Please post the sample data

[Anonymous]

Hi Please find the sample data.

[jagan]

HI,

Try like this

=Sum(Aggr(If(Count({<{Year=, Month, Quarter=, Date={'>=$(=MonthStart(Today(), -2))<=$(=MonthEnd(Today()))'}>} TransactionID) > 1, 1), Customers))

Regards,

Jagan.

[Anonymous]

Many Thanks Jagan I'll Try it.

Regards,

Raju

[Kushal_Chawda · Accepted solution]

Hi,

As per the Data I have considered the Year as 2014.

Do you need count of customer who made sales twice or more than twice? I have considered twice.

Please see the attached file. !

[Anonymous]

Thanks a lot brother....

[qlikviewwizard]

Hi jagan,

Good trick.