Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Aditya,
Can you add your QVF maybe to show us what you are doing? Thanks!
Jordy
Climber
Hi I am sharing excel file in this we have 4 week and 2 columns in each week and at dimensionality 1 we have GL and at dimensionality 2 we have lob and at dimensionality 3 we have cat. So here I am trying to get week on week for (OO V)/(Total V) percentage. for example if we select all weeks in week filter then the current week will be 30 and pervious week will be 29 and we need to calculate (OO V)/(Total V) for week 30 - (OO V)/(Total V) for week 29 and we need percentage difference . And if we select only one week in week filter then current week will be that week only but previous week will be week-1.
Please help me in this I am new to qlik.
Thanks
Aditya
HI Aditya,
I guess you also have a non pivot format of you data right?
Jordy
Climber