Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How do I combine multiple dimensions or measures into one bar graph

I am new to Qlik. This sounds like it sounds fairly trivial but I have looked around and can't seem to find the right answer.

I have a spreadsheet data source that I loaded. In my example below I have I have 7 data columns that I need to roll into one bar graph. I want to count the occurrences of the answers that do not start with 'NO' for each column and have them each appear as a bar in the chart.

 

Qual2r1Qual2r2Qual2r3Qual2r4Qual2r5Qual2r6Qual2r7
ABCDEFG
NO TO: ANO TO: BNO TO: CNO TO: DNO TO: ENO TO: FNO TO: G
ANO TO: BCDENO TO: FNO TO: G

After some digging I have seen two options a custom data load statement and a field formula.

The formula I came up with looks like this but only the first entry counts correctly when I apply the measure, It is in the field expression for the dimension

if(WildMatch(Qual2r1,'Evaluate*'),'Evaluate sec. mgmt. tools',

if(WildMatch(Qual2r2,'Approve*'),'Approve/purchase sec. mgmt. tools',

if(WildMatch(Qual2r3,'Deploy*'),'Deploy/support sec. mgmt. tools',

if(WildMatch(Qual2r4,'Plan net*'),'Plan networks using sec. monitoring tools',

if(WildMatch(Qual2r5,'Manage/monitor*'),'Manage/monitor networks using sec. mgmt tools',

if(WildMatch(Qual2r6,'Troubleshoot*'),'Troubleshoot networks using sec. mgmt. tools',

//if(WildMatch(Qual2r7,'None*'),'None of the above',

))))))

Any direction is appreciated on this or the proper load statement.

Thank you