8 Replies Latest reply: Nov 29, 2016 10:03 AM by Michael Tarallo RSS

    Help with Expression Editor in Qlik Sense Cloud

    Steve Rubinowitz

      Looking for help with Qlik Sense Cloud.  I am adding a measure to a bar graph.  I have a field (Comment) in my table that only has data in some lines.  I only want the graph to display a count on the lines that have a comment.  I was trying to write a "When" clause in the expression editor but I cannot seem to get it to work.

       

      As an example, I may have a total of 50 lines but only 4 have data in the Comment field.  If I add 2 measures, 1 for total encounters and 1 for comment, I want to see 2 bars in the graph, 1 displaying all 50 Encounters and 1 displaying 4 Comments

       

      Any assistance or suggestions would be greatly appreciated.