Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Not applicable

Sum Calculation

Hi.

i would like to show the  percentage calculation of the article No per MainArticle without Selecting the dimension Main Article as in the picture below the first.

is it poosible to calculate on partial total?

Problem.jpg

attached is the qwv.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Sum Calculation

Try

=[Total Complaint] /

sum( TOTAL<MainArticle> aggr(if([Item number]<>MainArticle ,' ',Sum ( InvoiceQty)),[Item number]))

View solution in original post

1 Reply
Highlighted
MVP
MVP

Re: Sum Calculation

Try

=[Total Complaint] /

sum( TOTAL<MainArticle> aggr(if([Item number]<>MainArticle ,' ',Sum ( InvoiceQty)),[Item number]))

View solution in original post