calculating sales % of parent in qlikview

[warrenpress]

Hi,

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

W

[MK_QSL · Accepted solution]

If(Dimensionality() = 3, SUM(sales)/SUM(TOTAL <month,year> sales),

If(Dimensionality() = 2, SUM(sales)/SUM(TOTAL <year,week> sales)))

[jagan]

Hi,

Try like this

For Week =Sum(Sales)/ Sum( TOTAL <Year,Month> Sales)

For Month=Sum(Sales)/ Sum( TOTAL <Year> Sales)

Regards,

Jagan.