topic Re: Plotting certain values on chart from an excel file in QlikView

Plotting certain values on chart from an excel file

Mon, 03 Dec 2012 16:06:17 GMT

Hi all,

I have got data that looks similar to this:

Continent	Country	City	Population
Asia	China	H.kong	20000
Asia	Japan	Shanghai	125200
Asia	India	Mumbai	7458795
Africa	S.africa	Johannesburg	124578
Africa	Nigeria	abc	1247953
Europe	Italy	Rome	23365487
Europe	Spain	Madrid	9874561
Europe	Portugal	Lisbon	2379451

I am looking to plot a bar graph only for the continent "Europe".

When I select Dimensions in Chart properties and select Continent, then all the continents graph comes up.

Can I get the expression please (Where does this expression need to be added)

How do I select only certian values which is 'Europe' in this case.

Regards,

K.V

Re: Plotting certain values on chart from an excel file

MEllinghausen — Mon, 03 Dec 2012 16:10:34 GMT

the simple Way, you choose Europe from a Listbox

Re: Plotting certain values on chart from an excel file

Mon, 03 Dec 2012 16:14:10 GMT

Hi Marcus,

I am looking to create a bar graph of Europe for which expression needs to be added while selecting dimensions in chart properties. I would like to know the expression and where to add the expression..

Regards,

K.V

Re: Plotting certain values on chart from an excel file

MayilVahanan — Mon, 03 Dec 2012 17:07:11 GMT

Try like this

=Sum({<Continent={'Europe'}>} YourExpression)

Hope it helps

Re: Plotting certain values on chart from an excel file

Mon, 03 Dec 2012 17:21:08 GMT

Hi all,

I found the solution for it.

The expression is:

If ( [Continent] = 'Europe', 1, Null() )

- Tick on the check box where it says supress null values

Thanks.

Regards,

K.V