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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I access the totals sum of a grid column?

I have a grid

A   B

1   1/(1+2+3)

2   2/(1+2+3)

3   3/(1+2+3)

how can I get the desired results of column 'B' by using formulae, value of 'A' are coming from expressions so they keeps on changing.

Any thoughts?

Best Regards,

Gaurav Tyagi

13 Replies
Not applicable
Author

Hey Anthony use this equation for B

B= sum(A)/sum(Total A)

Hope it helps.

Have a nice day

Gaurav

Not applicable
Author

Nope I didnt used it in the script.

But I found a way to do it

Thanks for your help

Gaurav

Not applicable
Author

Hi Gaurav,

Very helpful!

Thanks again for your help,

Anthony

Not applicable
Author

Hi Gaurav,

Very helpful!

Thanks again for your help,

Anthony