topic Re: Line Chart in QlikView

Line Chart

anuradhaa — Thu, 27 Sep 2012 09:43:23 GMT

I have a line chart,

Demenssion is date,

expression is sales

and i have this data for 5 different countries

i need to create 5 seperate different graphs for those 5 countries.

i know i can do it by putting country and date as a demenssions.

but then i get combine graph.

But i need to get isolated graphs.

Is there any way to do this.

Thanks

Re: Line Chart

Anonymous — Thu, 27 Sep 2012 09:52:11 GMT

If you want 5 different graphs with one line in each you can either use Set Analysis and hard code one country into each chart.. or look at using trellis charts I guess

Re: Line Chart

Thu, 27 Sep 2012 09:52:53 GMT

Hi,

Do u want to create seperate chart for different countries....right.... then take Calculated Dimension & write code for that particular country...

for ex: if(Country='India',Country)....Add this exp. into calculated Dimension Field...it will give Data for India Only.

Re: Line Chart

swuehl — Thu, 27 Sep 2012 09:53:23 GMT

You can for example use the Trellis option in dimension tab to get separate graphs per country.

Or just create separate chart objects yourself, manually, one for each country.

Re: Line Chart

anuradhaa — Thu, 27 Sep 2012 09:56:24 GMT

Thanks,

I have used date as a dimension.

Could you please explan me more deeply

Thanks

Re: Line Chart

Thu, 27 Sep 2012 09:58:53 GMT

so u can use this exp...

=sum({<Country={'India'}>}Sales)..

it will give data for Country India only

Re: Line Chart

anuradhaa — Thu, 27 Sep 2012 10:43:04 GMT

Thanks you Very Much,

But i have another additinal question for you

I have countries,

USA

INDIA

CHINA

FRANCE
GERMANY

and Rest Of the world.

Then i can create separate graphs for all above countries using your code.

But i have a problem in rest of the world.

Could you please help me in this.

Thanks

Re: Line Chart

Thu, 27 Sep 2012 10:51:43 GMT

'Rest of the World ' its a value of country Field?....

if yes..then u can use directly...

=sum({<Country={'Rest of the World '}>}Sales)

Another Way is....

=sum({<Country-={'USA','UK','INDIA','CHINA','FRANCE','GERMANY'}>}Sale)

here...it will exclude those country & will give sum of sale for rest of the world......

-= is act as not equal to in set analysis

Re: Line Chart

anuradhaa — Wed, 03 Oct 2012 13:27:47 GMT

Hi I have another Problem,

Here i need to create a "GAUGE Chart" for above Thing, But the problem is i only want it for latest date

Max(Date),

How can i create a GAUGE Chart for display only max date data