# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New 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

W

1 Solution

Accepted Solutions
Highlighted
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)))

2 Replies
Highlighted
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)))

Highlighted
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.