Replicate same chart for different countries in same sheet

[#1]

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.

[oknotsen]

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

[sunny_talwar]

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

You can find it under the chart properties:

Best,

S

[maxgro]

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

There is a trellis tab with 2 examples

[#5]

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

[awhitfield]

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

[oknotsen]

What version of QlikView are you running?

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

[richard_pearce6]

Can you check your chart type?

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

Richard

[#9]

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?

[oknotsen]

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.