Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Need help on count the customers in straight table

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

1 Solution

Accepted Solutions
Kushal_Chawda

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. !

View solution in original post

7 Replies
Kushal_Chawda

Please post the sample data

Anonymous
Not applicable
Author

Hi Please find the sample data.

jagan
Partner - Champion III
Partner - Champion III

HI,

Try like this

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

Regards,

Jagan.

Anonymous
Not applicable
Author

Many Thanks Jagan I'll Try it.

Regards,

Raju

Kushal_Chawda

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
Not applicable
Author

Thanks a lot brother....

qlikviewwizard
Master II
Master II

Hi jagan,

Good trick.