Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rglenn0780
Contributor

Calculation condition Qlik Sense

Hello,

I am attempting to display the bottom 10 product lines with a combo-bar chart of Capital and Operating Income. I am struggling because I am leading with capital, which is what I want to sort on, but I would like to see the values that are greater than 0 in this specific chart. The bottom 10 for capital include lots of zero capital product lines but the operating income is positive. Is there a way to write a calculation condition that says if capital = 0 and operating income is >0, then display as 0 so I can get to the product lines that have positive capital and operating income?

Measures:

wCapital

wOI

Thanks so much for all you do.

Tags (1)
1 Reply
luismadriz
Valued Contributor

Re: Calculation condition Qlik Sense

HI Russell,

Can you please share a sample app?

Cheers,

Luis