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