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

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
wizardo
Creator III
Creator III

sum(sales) only for returning customers between 2 dates...how?

hi good fellas,

i need to sum the sales only for customers who bought more then once between 2 (user selected) Dates.

...

the user have selected 01/02/2009 - 31/03/2009

i want only customers who bought more then once during that period to be included.

there are other filters involved but thats the only one i couldnt figure out

any help would be greatly appreciated

Mansyno

10 Replies
Not applicable

hi wizardo, as u said the non returning customers will be having sales 0. Then in the property of the chart, there is something like 'Suppress Zero Values'. On selecting that, customers with 0 sales won't be displayed. In this case, it means, non-returning customers won't be displayed.