Discussion Board for collaboration related to QlikView App Development.
I need to compare results of each quarter + year to its previous quarter + year. I tried different options suggested on community but it didn't helped as i have customer and other dimension to it. here is the data.
I got above results with Pivot Table. For me the next step is to get the difference of each quarter compared with earlier year quarter like below--- yellow marked
Please help out... Thanks
Once again proved, you are genius...:)
That worked perfectly, only one thing, if no value in previous quarter it goes one more previous level.
But for me that is logical when you are comparing results to previous year/quarters
Thanks You very much !!!
can we add the sum of columns year-wise now? The number of years are random and will increase in future so don't have fixed column count