Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thank you