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.
Qual2r1
Qual2r2
Qual2r3
Qual2r4
Qual2r5
Qual2r6
Qual2r7
A
B
C
D
E
F
G
NO TO: A
NO TO: B
NO TO: C
NO TO: D
NO TO: E
NO TO: F
NO TO: G
A
NO TO: B
C
D
E
NO TO: F
NO 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.
