Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Replicate same chart for different countries in same sheet


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.

15 Replies
Master III
Master III

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

May you live in interesting times!

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

You can find it under the chart properties:

Best,

S

MVP
MVP

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

There is a trellis tab with 2 examples

Not applicable

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

Partner
Partner

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

Master III
Master III

What version of QlikView are you running?

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

May you live in interesting times!
Luminary
Luminary

Can you check your chart type?

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

Richard

Not applicable

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?

Master III
Master III

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.

May you live in interesting times!