Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

dominicanlauf
New Contributor III

sum up different values

Hello everybody,

I have a table that should sum up the pieces produced. There is a product A and a product B, which differ by the property "cylinder = 0 or> 0".

I would like to look at the number of produced pieces  of both products separately.

My idea was: if (cylinder = 0, sum (productionstatistic.produced))

if (cylinder> 0, sum (productionstatistic.produced)

This does not work.

Does anyone know how to solve the problem?

Thanks!

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: sum up different values

Try: sum ({<cylinder={0}>}productionstatistic.produced)

Make sure to use the correct case sensitive field names.


talk is cheap, supply exceeds demand
1 Reply
MVP & Luminary
MVP & Luminary

Re: sum up different values

Try: sum ({<cylinder={0}>}productionstatistic.produced)

Make sure to use the correct case sensitive field names.


talk is cheap, supply exceeds demand