Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ecabanas
Creator II
Creator II

filtering results in set analisys

Hi all,

 

I'm doing a vertical graph bar that shows the number of customer per category. For example if I select 2019 and October, I'll have the results for last 12 months.

 

Count({<[SalesId]={"PV0***"},CalendarYear_C =,CalendarMonthName_C=,CalendarMonthAndYear_C={">=$(=addmonths(max(CalendarMonthAndYear_C),-12)) <=$(=Max(CalendarMonthAndYear_C))"}>} Custaccount)

 

But in the the graph I want to show the numbers in sections, number of customer that only bough once in this 12 months, between 2 and 9 and more than 9

2019-11-07_12h03_17.png

I don't know how to do that graph,

Thanks for your help 

0 Replies