Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count values per category

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. 

3 Replies
sunny_talwar

Use a calculated dimension such as this:

If(Match(Groups, 'Group1', 'Group2', ...), Bar1Name, Bar2Name)

Clever_Anjos
Employee
Employee

It would be easier to help if you post some data and maybe some picture of what you want

MarcoWedel

Hi,

one solution might be:

QlikCommunity_Thread_163004_Pic2.JPG

QlikCommunity_Thread_163004_Pic3.JPG

QlikCommunity_Thread_163004_Pic1.JPG

hope this helps

regards

Marco