set analysis

[MeeraAgrawal]

Hi Guys 

I am new in Qlik sense I have created a measure for calculating Revenue  like below expression 

vRevenue=sum(1[Unit Sold])*sum([Price per unit])

but its showing same value for all of the product. I have attached screenshot for your reference please let me know what are the issue?

[Durgadevikumar]

Hi meera,

if you put 1 as s set identifier then it takes the complete data set. And it is exclude the current selection.

so use $ instead of 1,

vRevenue=sum({$}[Unit Sold])*sum({$}[Price per unit])

regards,

Durga

[agigliotti]

i'm not so sure but you can try this:

vRevenue = sum( [Unit Sold] * [Price per unit] )

I hope it can helps.

[MeeraAgrawal]

It's not working showing same value for all products. please find attached screenshots.

[Durgadevikumar]

use 

vrevenue=sum({$}[Unit Sold]*[Price per unit])  in variable overview

and call by,

=$(Vrevenue) in your chart

Regards,

Durga