Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hlines_usacs
Contributor II

Using SUM within Set Anlysis

Hello, I have a line chart that shows 4 measures, like those below, and a Month dimension. I want to limit those to show when the sum of measure 1 is > 0 for each month.

Current Expressions:

SUM({<[Field]={'Source1'}>} [Measure1] )

SUM({<[Field]={'Source1'}>} [Measure2] )

SUM({<[Field]={'Source1'}>} [Measure3] )

SUM({<[Field]={'Source1'}>} [Measure4] )

This is what I want:

SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure1] )

SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure2] )

SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure3] )

SUM({<[Field]={'Source1'}, SUM({<[Field]={'Source1'}>} [Measure1] ) > 0 >} [Measure4] )

Can someone help me with the syntax or know of another way to do this?

Thanks1

1 Solution

Accepted Solutions

Re: Using SUM within Set Anlysis

May be this

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure1]) > 0"}>} [Measure1])

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure2]) > 0"}>} [Measure2])

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure3]) > 0"}>} [Measure3])

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure4]) > 0"}>} [Measure4])

2 Replies

Re: Using SUM within Set Anlysis

May be this

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure1]) > 0"}>} [Measure1])

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure2]) > 0"}>} [Measure2])

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure3]) > 0"}>} [Measure3])

Sum({<[Field] = {'Source1'}, Month = {"=Sum({<[Field] = {'Source1'}>} [Measure4]) > 0"}>} [Measure4])

hlines_usacs
Contributor II

Re: Using SUM within Set Anlysis

It works! Thank you!

Community Browser