Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
anuradhaa
Contributor

Line Chart

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

1 Solution

Accepted Solutions
Not applicable

Re: Line Chart

so u can use this exp...

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

it will give data for Country India only

8 Replies
jsn
Honored Contributor

Re: Line Chart

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

Not applicable

Re: Line Chart

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.

MVP
MVP

Re: Line Chart

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.

anuradhaa
Contributor

Re: Line Chart

Thanks,

I have used date as a dimension.

Could you please explan me more deeply

Thanks

Not applicable

Re: Line Chart

so u can use this exp...

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

it will give data for Country India only

anuradhaa
Contributor

Re: Line Chart

Thanks you Very Much,

But i have another additinal question for you

I have countries,

USA

UK

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

Not applicable

Re: Line Chart

'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

anuradhaa
Contributor

Re: Line Chart

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

Community Browser