Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
MarioCenteno
Creator III
Creator III

Graph bars customer sales with monthly status change

Hi, I'm trying to create a graphic that shows me the status of a client's sale.

 

I need to know when a customer changes status "A" to "C" from one month to the next.

 

For example: January 500 customers with "A" status February Of the 500 clients of the month of January, 100 clients changed to "B" status.

Dimension:

=if([CSMO_ACTUAL] = 0 and [CSMO_ANT]= 0,'A', if([CSMO_ACTUAL] = 0 , 'B',
if(CSMO_ACTUAL-(CSMO_ANT)>0,'C','D')))

 

Expression 

COUNT({<[FECHA_TEMP.autoCalendar.Year]={'$(vMaxYear)'}, [FECHA_TEMP.autoCalendar.Month]={'$(vMaxMonth)'},
[FECHA_TEMP.autoCalendar.Day]={'<=$(vMaxDay)'},
FECHA_TEMP=,[FECHA_TEMP.autoCalendar.YearMonth]=>}ID)

I hope u can help me 🙂

 

Labels (1)
0 Replies