Discussion Board for collaboration related to QlikView App Development.
I have a pivot chart with 3 dimensions, year, month and week.
What expression do i need to use to get week to show as % of month and month as % of year etc.
At present I am using =sum(Total sales) but it is only showing the week and month as a % of the year
Thanks in advance
If(Dimensionality() = 3, SUM(sales)/SUM(TOTAL <month,year> sales),
If(Dimensionality() = 2, SUM(sales)/SUM(TOTAL <year,week> sales)))
View solution in original post
Try like this
For Week =Sum(Sales)/ Sum( TOTAL <Year,Month> Sales)
For Month=Sum(Sales)/ Sum( TOTAL <Year> Sales)