In a Graphic table compare sumof value for the current month and previous month

Touix — Wed, 19 Jul 2023 11:03:02 GMT

Hello Everybody,

I join a qlikview document.

I have a problematic that seems very very very simple, but since 2 days i am totally blocked.

I have sum of cancellation and subscription by month.

I want to compare the result of the sum with the previous month.

EFF : load *, date#(DATE_CHAR,'DD/MM/YYYY') as DATE ; LOAD * INLINE [ DATE_CHAR, TOP_CANCEL, TOP_SUBSCRIPTION , ID_CLIENT '01/01/2022' , 0 ,1 , 1 '01/01/2022' , 1 ,1 , 2 '01/01/2022' , 1 ,0 , 3 '01/02/2022' , 0 ,1 , 4 '01/02/2022' , 1 ,1 , 5 '01/02/2022' , 1 ,0 , 6 '01/02/2022' , 1 ,1 , 7 '01/12/2022' , 1 ,0 , 8 '01/01/2023' , 1 ,0 , 9 '01/01/2023' , 0 ,1 , 9 '01/02/2023' , 1 ,0 , 10 '01/11/2023' , 1 ,0 , 11 '01/11/2023' , 1 ,0 , 12 '01/11/2023' , 1 ,0 , 13 '01/12/2023' , 1 ,0 , 21 '01/12/2023' , 1 ,0 , 22 '01/12/2023' , 1 ,0 , 23 '01/12/2023' , 0 ,1 , 24 ];

I have create a set analysis in a graphic table with DATE as dimension like this :

sum({<DATE={"$(=addmonths( (DATE),-1))"} >} TOP_CANCEL)

But results diplay are 0 ...

Can you tell me what is wrong in my logic ?

Thank you

topic In a Graphic table compare sumof value for the current month and previous month in App Development

In a Graphic table compare sumof value for the current month and previous month