Discussion board where members can get started with Qlik Sense.
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.
=if([CSMO_ACTUAL] = 0 and [CSMO_ANT]= 0,'A', if([CSMO_ACTUAL] = 0 , 'B',if(CSMO_ACTUAL-(CSMO_ANT)>0,'C','D')))
I hope u can help me 🙂