topic Re: Replicate same chart for different countries in same sheet in QlikView

Replicate same chart for different countries in same sheet

Thu, 19 Mar 2015 14:31:33 GMT

Is it possible to create same type of charts e.g. a line chart showing Sales vs Revenue for a country and replicate this chart for different countries in the same sheet . Or lets say is there a way to multi select countries from a list box and have each chart linked to each selection in the list box?

Thanks for your help.

Re: Replicate same chart for different countries in same sheet

oknotsen — Thu, 19 Mar 2015 14:33:30 GMT

Make a chart and turn on "trellis" (bottom left on the Dimension tab) aimed at the country dimension.

Re: Replicate same chart for different countries in same sheet

sunny_talwar — Thu, 19 Mar 2015 14:36:41 GMT

Trellis is what you want to do as pointed out by okg

You can find it under the chart properties:

Best,

Re: Replicate same chart for different countries in same sheet

maxgro — Thu, 19 Mar 2015 14:41:56 GMT

open Data Visualization.qvw, usually in C:\Program Files\QlikView\Examples\Documents (QlikView install folder)

There is a trellis tab with 2 examples

Re: Replicate same chart for different countries in same sheet

Thu, 19 Mar 2015 14:45:36 GMT

Thank you for getting back. Looks like I dont have access to Trellis through my version, any workarounds?

Re: Replicate same chart for different countries in same sheet

awhitfield — Thu, 19 Mar 2015 14:51:16 GMT

What sort of chart have you chosen in the screen shot above, it should be available for all except Pivot and Straight Table Charts.

Andy

Re: Replicate same chart for different countries in same sheet

oknotsen — Thu, 19 Mar 2015 14:52:20 GMT

What version of QlikView are you running?

Trellis should be available on most charts since QlikView 11 (and probably earlier versions).

Re: Replicate same chart for different countries in same sheet

richard_pearce6 — Thu, 19 Mar 2015 14:53:51 GMT

Can you check your chart type?

Trellis won't be enabled if you're using a straight table or pivot table.

Richard

Re: Replicate same chart for different countries in same sheet

Thu, 19 Mar 2015 14:57:31 GMT

I'm running Qlivkiew 11 , but yes the chart type in question here is Pivot chart and Trellis is available with other chart types. Thank you so much for getting back. But is there a way I could use it for Pivot charts?

Re: Replicate same chart for different countries in same sheet

oknotsen — Thu, 19 Mar 2015 15:00:00 GMT

No.

However, you could explain your use case and maybe there is a better solution to the problem than using a Pivot table.

But since it is a Pivot table, why not just add the country as the first Dimension; that should automatically make all other dimensions stacked on top of that and cause the result you want.

If not, please re-explain your problem.

Re: Replicate same chart for different countries in same sheet

Thu, 19 Mar 2015 15:22:09 GMT

Per Requirement the data needs to be presented in a pre-defined tabular format and not in the form of a chart hence its necessary to use straight table or pivot table. In my case pivotting helps hence i ended up using pivot table.

ITs data showing sales and revenue as measures for different prodcuts across different months.

Re: Replicate same chart for different countries in same sheet

oknotsen — Thu, 19 Mar 2015 15:44:23 GMT

I am getting the feeling you are using QlikView as a reporting tool, not as an analysis tool .

It can be arranged what you want, but you will have to use Set Analysis for every chart pointing at one country.

Maybe ask the customer what the question is he is trying to answer (and than answer that question) instead of trying to build the answer he has in mind?

Re: Replicate same chart for different countries in same sheet

Thu, 19 Mar 2015 15:49:19 GMT

Yes correct, we are using it as a reporting tool. Set Analysis is what came to my mind as the first option but the list of countries we would like to analyse or present at a time change often based on few conditions. Hence the other solution is thought was to display the list of specific countries via SQl logic into list box and then if there is a way that i can represent the chart pointing to each country present in the list box.

Re: Replicate same chart for different countries in same sheet

richard_pearce6 — Thu, 19 Mar 2015 16:39:16 GMT

You could add the country to the pivot table as mentioned above and then drag/move the dimension to the top of the chart.

Re: Replicate same chart for different countries in same sheet

Thu, 19 Mar 2015 17:26:36 GMT

Dragging the country to the top as dimension wont help since we need isolated pivot tables for each country.

Country: US

Products Sales Revenue

A aaa bbb

B xtrrr cccc

Country: UK

Products Sales Revenue

A aaa bbb

B xtrrr cccc

one after the other for each country where the countries keep on changing dynamically.

Re: Replicate same chart for different countries in same sheet

Thu, 19 Mar 2015 17:27:35 GMT

I have a fixed image of the type of the report that they need and it needs to look exactly like that one.