Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

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.

1 Reply
Highlighted
Specialist
Specialist

HI Russell,

Can you please share a sample app?

Cheers,

Luis