3 Replies Latest reply: May 6, 2015 5:37 PM by Marco Wedel RSS

    Count values per category

    Martijn Noorda

      Hello,

       

      I am quite new to Qlikview. My loading script should now be correct, but I am now having trouble displaying the correct data in my graphs.

       

      My data table consists of ID's group category indicators and of course other fields

       

      I want to have a barchart that counts the null values per category. I have done that, but I actually do not want to group by the groups as present in the category field, but I want to make new groups out of those values.

       

      I have 9 different groups, which results in a bar chart with 9 bars, 1 per group. I actually want 1 bar for a particular group value, and one bar for all the rest. Would I need to make a new field in my script or could I write this in my bar chart dimensions?

       

      Thanks in advance for your help.