Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master
Master

aggregate the column values

Hi all,

i have a column in pivot table     product%      it is showing % correct   

 

but i need to show that total      aggregating all columns values /no of rows   .  

 

how to achieve this?

 

 

Labels (1)
1 Solution

Accepted Solutions
Highlighted

May be try this

((Sum(Total(Aggr(fabs(sum(FC_QT)-sum(AP_QT)),ID)))*sum(AP_QT))/sum(total AP_QT))
/
Count(DISTINCT id)

View solution in original post

6 Replies
Highlighted

I suggest you post some sample data and your required output to better explain your requirements. Post as text, not as images and you will get more relevant and accurate responses.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Master
Master

HI  

attached sample 

Highlighted

What is your expression that you are using for Product%?

Highlighted
Master
Master

Hi @sunny_talwar   

 

below is the used expression

=()

Highlighted

May be try this

((Sum(Total(Aggr(fabs(sum(FC_QT)-sum(AP_QT)),ID)))*sum(AP_QT))/sum(total AP_QT))
/
Count(DISTINCT id)

View solution in original post

Highlighted
Master
Master

its worked thank you 🙂