New to qlikview - expression help please

[#1]

Please can someone help me with an expression.

Fields:

Material

New Product  (either 1 or 0)

Sales Value

I want to create an expression to calculate the total value of a material where the New Product field contains 1.

I appreciate this is very easy but I'm a complete newbie

Thank you!

[tresesco · Accepted solution]

Sum({<[New Product]={1}>} [Sales Value])

[ashfaq_haseeb]

Hi,

Try below

Dimension

Material

Expression:

Sum({<[New Product]={1}>}[Sales Value])

Regards

ASHFAQ

[SunilChauhan]

Sum({<[New Product]={'1'}>} [Sales Value])

or

sum(if(New Product]=1 ,[Sales Value]))

[#5]

Try this:

=Sum({$<[New Product] = {1}>} Material)

Hope it helps!