Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Make a chart and turn on "trellis" (bottom left on the Dimension tab) aimed at the country dimension.
Trellis is what you want to do as pointed out by okg
You can find it under the chart properties:
Best,
S
open Data Visualization.qvw, usually in C:\Program Files\QlikView\Examples\Documents (QlikView install folder)
There is a trellis tab with 2 examples
Thank you for getting back. Looks like I dont have access to Trellis through my version, any workarounds?
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
What version of QlikView are you running?
Trellis should be available on most charts since QlikView 11 (and probably earlier versions).
Can you check your chart type?
Trellis won't be enabled if you're using a straight table or pivot table.
Richard
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?
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.