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

Set Analysis on total value

Hi all,

I loaded sales by item (two columns: item and quantity) and create a table with these two values.

Now I would like to calculate the total quantity as the sum of all the item quantities , and add this value as third column in the table (so these column should contain always the same value, because it is a total).


This is what I would like to have:

itemquantitytotal quantity
A1024
B524
C824
D124

I tried to create a new measure but when I add it to the table the value is always related to the item, it's not the total. I tried with this code but it doesn't work:

sum( { < item_id = { "*" } > }  invoiced_qty)

How could I change the measure in order to have the total value?

Thanks

stefano

0 Replies