topic Re: New to qlikview - expression help please in QlikView

New to qlikview - expression help please

Thu, 24 Jul 2014 10:13:10 GMT

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!

tresB — Thu, 24 Jul 2014 10:15:33 GMT

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

ashfaq_haseeb — Thu, 24 Jul 2014 10:16:02 GMT

Hi,

Try below

Dimension

Material

Expression:

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

Regards

ASHFAQ

SunilChauhan — Thu, 24 Jul 2014 10:17:30 GMT

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

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

Thu, 24 Jul 2014 10:17:37 GMT

Try this:

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

Hope it helps!