Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

guitartrova
Contributor 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 (2)