topic Re: Creating a percentages bar graph in QlikView

Creating a percentages bar graph

Mon, 23 Mar 2015 19:19:10 GMT

I am new to QlikView and need help making a simple bar graph.

I have a dataset with survey responses for every region we serve. I need only one region and need the results to be a percentage (for only that specified region). I created the graph with only one dimension (the question I am looking at) and created the expression, but the numbers are not right.

Any help is greatly appreciated:

Count(If(Region = 'Southeast',[Q25]))
/
Sum(If(Region = 'Southeast',[Q25]))

What am I doing wrong?

Re: Creating a percentages bar graph

Anonymous — Mon, 23 Mar 2015 19:38:37 GMT

Set Analysis is something you will need to learn to effectively use QlikView.

Count(${<Region = {'Southeast'}>} [Q25])

Sum(${<Region = {'Southeast'}>} [Q25])

It's basically saying always have Southeast selected in the Region listbox.

Re: Creating a percentages bar graph

saurabh5 — Mon, 23 Mar 2015 19:47:42 GMT

hi Karen,

if you are targeting only one region then probably your numerator has to be only 'Southeast' divided by total set.

try something like this:

Count(${<Region = {'Southeast'}>} [Q25])

Count( [Q25])

then Change the number Format in your bar chart as ###.#0%. To get values in percentage.

Re: Creating a percentages bar graph

Anonymous — Mon, 23 Mar 2015 19:47:59 GMT

A wild guess here, as I don't really understand your scenario, but.................

What possible values does [Q25])have ?

If it is 0 and 1 then try an expression like :

Sum([Q25])/ Count([Q25])

Use Region as your Dimension. All going well you should now have a Bar Chart of all your regions.

If ok then create a List Box on Region and select 'Southeast'.

Re: Creating a percentages bar graph

Thu, 02 Apr 2015 11:38:29 GMT

Thank you, this Set Analysis thing is very useful. I ended up using this with the denominator as a Count, Total.

Re: Creating a percentages bar graph

buzzy996 — Thu, 02 Apr 2015 11:56:57 GMT

u can simply use Michael.Gardner suggestion.