Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to set sum of a column as the value of a column

I am making a pivottable. I have diffrent types of articles as rows. Som of the articles are specially marked in [no1] as 1.

I have made a column that shows how many of my special products i have sold. Now - i want to make a column that shows total of sold special products - regardless of product number. In the example below, that column will show 7072 in each single cell.

Is that possible? I have tried a litte bit of stacked aggregation, but with no luck so far.

Please help me!

2017-05-28 18-24-26.png

11 Replies
Anonymous
Not applicable
Author

I want the whole columns to show same value. I didn't mean to make some numbers negative, as in the picture above.

gladi-cz
Creator
Creator

Well,it should be done. I solved in script part.

Capture.JPG