Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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