Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
stefanobl
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

Tags (1)