Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
felcar2013
Partner - Creator III
Partner - Creator III

customer history for current and previous month

Hi

i would like to Display a table like this, where i Show as Dimension the history of the customers and as expresions

1. a Count distinct of customers showing the number of the current month and

2. a Count distinct of customers showeing the number of the previous month

for ex. the row with 2015/10 Shows 15 for "this month" column and for the "previous month" column, it shall be 12. I attached a file with this data,thanks

4 Replies
sunny_talwar

Try this:

Below(Count({<date = >}DISTINCT customer))


Capture.PNG

felcar2013
Partner - Creator III
Partner - Creator III
Author

thanks, not exactly what i wanted, but in the end it Displays exactly what i need!

sunny_talwar

What are you looking for? May be we can help

felcar2013
Partner - Creator III
Partner - Creator III
Author

i wanted to get the variable "previous month" in the Expression correctly