topic Re: How to Create different charts for different selection in a sheet? in QlikView

How to Create different charts for different selection in a sheet?

Tue, 03 Sep 2013 18:39:05 GMT

Hi ,

Is there any way of creating different charts for different selections in the same sheet of Qlikview document.

My requirement is to display relevant chart with respect to a particular selection hiding the other charts.

Thanks,

Vaneet

Re: How to Create different charts for different selection in a sheet?

Nicole-Smith — Tue, 03 Sep 2013 18:41:39 GMT

It sounds like you want to look into Alternate States.

(The Product Grouping tab on the "What's New in QlikView11.qvw" that comes with the QV11 install should give you an example of this.)

Re: How to Create different charts for different selection in a sheet?

Anonymous — Tue, 03 Sep 2013 19:07:21 GMT

You can do it using conditional show of the charts. One condition for one chart, another condition for another chart.

Re: How to Create different charts for different selection in a sheet?

jpapador — Tue, 03 Sep 2013 19:28:57 GMT

If you are using Qlikview 11, you want to use alternate states. You can turn on alternate states in the document properties on the general tab. Once enabled you can assign objects to different states on their individual general tabs in the object properties.

Re: How to Create different charts for different selection in a sheet?

rustyfishbones — Tue, 03 Sep 2013 19:56:48 GMT

Hi,

These videos shows how to conditionally display charts

Qlikview Design Variable by RFB 86 - YouTube

Qlikview Design Tip by RFB 92 - YouTube

I hope they help

Regards

Re: How to Create different charts for different selection in a sheet?

Tue, 03 Sep 2013 20:04:11 GMT

Not Exactly. My requirement is as below:

Suppose i have sales data with respect to regions (A,B,C,D....) now if i choose region A my graph should be a Bar chart,if i choose region B my graph should be a Line graph etc. means for every selection there has to be a different representation of data.

Thanks for the help.

Re: How to Create different charts for different selection in a sheet?

jpapador — Tue, 03 Sep 2013 20:10:57 GMT

Ah you could make a graph with 4 separate expressions. Then in the conditional bar for the expression do:

GetFieldSelections(region) ='A' For the first one

GetFieldSelections(region) ='B' for the second.... Etc. Make sure you make it a combo chart then you can select the different representations for each expression.

That way the expression will only show when its specific region is selected

Re: How to Create different charts for different selection in a sheet?

rustyfishbones — Tue, 03 Sep 2013 20:12:07 GMT

So you can create your charts and then add the following

IF(Region = 'A',1,0) or IF(Region = 'B',1,0) and so on for each region

Add the above IF statement to the Show Conditional in the layout tab for each chart.

Here is an attached image of where to change this

Re: How to Create different charts for different selection in a sheet?

Tue, 03 Sep 2013 20:28:00 GMT

Ok Thanks but what if i do not want to create combo charts and want to display completely new charts as per the regions.

Re: How to Create different charts for different selection in a sheet?

rustyfishbones — Tue, 03 Sep 2013 20:30:22 GMT

That where you would use my approach above

Re: How to Create different charts for different selection in a sheet?

rustyfishbones — Tue, 03 Sep 2013 20:30:56 GMT

So you can create your charts and then add the following

IF(Region = 'A',1,0) or IF(Region = 'B',1,0) and so on for each region

Add the above IF statement to the Show Conditional in the layout tab for each chart.

Here is an attached image of where to change this

Re: How to Create different charts for different selection in a sheet?

Anonymous — Tue, 03 Sep 2013 20:36:01 GMT

You can create different charts, and "show" conditions will be different for each chart:

region='A'

region='B'

region='C'

...

Regards,

Michael

Re: How to Create different charts for different selection in a sheet?

Wed, 04 Sep 2013 14:41:09 GMT

Thanks Alan.With your above mentioned approach i am able to show graph as per the selections but not exactly on the same place.I want to replace a chart exactly at the same place in my sheet as per the selection. I tried one approach by creating a clone but it's not very effective. Can you suggest something ?

Thanks,

Vaneet

Re: How to Create different charts for different selection in a sheet?

stigchel — Wed, 04 Sep 2013 14:51:39 GMT

You can use a container -> new sheet object\container -> include the different charts and position the container. The title of the chart will be used as selection option. You also do not need (and need to remove) the conditional show option.

Re: How to Create different charts for different selection in a sheet?

Anonymous — Wed, 04 Sep 2013 14:56:30 GMT

Vaneet,

To make sure the charts are in same place and the same size, you can use X-pos, Y-pos, Width, and Hight - all on the Caption tab.

Regards,

Michael

Re: How to Create different charts for different selection in a sheet?

rustyfishbones — Wed, 04 Sep 2013 14:56:32 GMT

When you create a new chart copy the x and y positions from the original chart

and then the new chart when selected from your button will cover the old chart

X-pos and Y-pos and the height and width should be the same to make it look correct

See below image

Re: How to Create different charts for different selection in a sheet?

Wed, 04 Sep 2013 15:43:50 GMT

Thanks all.

Re: How to Create different charts for different selection in a sheet?

rustyfishbones — Wed, 04 Sep 2013 15:45:16 GMT

you need to give points to the correct answer and helpful answers, so other users will find what they need!

Re: How to Create different charts for different selection in a sheet?

Sat, 21 Sep 2013 16:36:46 GMT

Hello Alan Farrell,

Its works fine, if we have subregion filter have 100 values how can we hard code in expressions in layout tab

Kindly send me any expression for this situation....

Regards,

Ram.