1 Reply Latest reply: Dec 21, 2017 12:22 AM by Luis Madriz RSS

    Calculation condition Qlik Sense

    Russell Glenn

      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.