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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number of Occurrences

Hi All, I have a dataset of the customers to an F&B outlet at a hotel. 

I would like to show the number of repeat guests to the restaurant each month so need to count the occurrences of each guest name and then show only those greater than 1 by month.  Can anyone advise on the script for this?

In the bar chart I would just like to show each month the number of repeat guests which I will show as a percentage of total guests for the month.


Thanks for your help!

0 Replies