Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
warrenpress
Contributor III
Contributor III

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
MK_QSL
MVP
MVP

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
MK_QSL
MVP
MVP

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

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

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

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

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

Regards,

Jagan.