Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

calculating sales % of parent in qlikview

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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: calculating sales % of parent in qlikview

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

2 Replies
Highlighted
MVP
MVP

Re: calculating sales % of parent in qlikview

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: calculating sales % of parent in qlikview

Hi,

Try like this

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

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

Regards,

Jagan.