topic Re: Container and Cycle Selection in QlikView

Container and Cycle Selection

cbaqir — Mon, 24 Aug 2015 17:48:23 GMT

I have a container with two charts: Level A and Level B.

I have an additional chart under the container with a button to Cycle between Level A view and Level B. My customer is asking if it is possible that when you select the Chart within the Container for Level A that the lower level filter shows Level A and if you select the Chart within the Container for Level B that the lower level filter shows Level B?

Thanks

Re: Container and Cycle Selection

marcus_sommer — Mon, 24 Aug 2015 20:03:48 GMT

Access to container-properties are only per macros possible therefore is the easiest way not to use container for such things else buttons which switch per variable the visibilty from these objects and variable could also be used for defining this label.

- Marcus

Re: Container and Cycle Selection

Mon, 24 Aug 2015 20:06:42 GMT

What about using alternate states - each container would be a different state and you can hve filter options associated with each state. This will allow only the specified chart to update based on selection criteria

Re: Container and Cycle Selection

cbaqir — Tue, 25 Aug 2015 14:34:12 GMT

Alternate states is not an option for this because there are list boxes than need to apply to both.

Re: Container and Cycle Selection

cbaqir — Tue, 25 Aug 2015 14:34:59 GMT

I have a button right now but the customer wants to switch the values without having to click a button.

Re: Container and Cycle Selection

Tue, 25 Aug 2015 14:37:44 GMT

sorry - did not understand that part

what about set analysis based on the value(s) selected?

Re: Container and Cycle Selection

marcus_sommer — Tue, 25 Aug 2015 14:41:15 GMT

The buttons (and maybe other objects like a textbox as frame within background) could be (relative easily) styled like a container so the user won't notice any difference.

- Marcus

Re: Container and Cycle Selection

cbaqir — Tue, 25 Aug 2015 15:51:28 GMT

Can you do set analysis for which chart is selected to trigger which Cycle view another chart shows?

Re: Container and Cycle Selection

cbaqir — Tue, 25 Aug 2015 15:52:51 GMT

The charts within the container are pretty complex straight tables with a lot of values so I don't think the text box option would work. Also, we don't want buttons. If a user selects Level A chart in the container, the lower graph would show the Cycle for Level A.

Re: Container and Cycle Selection

Tue, 25 Aug 2015 15:59:55 GMT

any chance of getting the app with scrambled data or a smaller version of the app with test data - having a difficult time vizualizing and understanding

Re: Container and Cycle Selection

cbaqir — Tue, 25 Aug 2015 16:00:50 GMT

I'll work on that.

Re: Container and Cycle Selection

marcus_sommer — Tue, 25 Aug 2015 16:03:14 GMT

The charts itself didn't need to be touched unless to limit their max. size which would be else limited through the container. The buttons looked like the container tabs and switch only the variable value which would control the chart visibilty - it's quite the same what the container does. The user won't be notice which objects he/she used - and you avoid all possible problems which occur if you need to access the container-properties.

- Marcus

Re: Container and Cycle Selection

Oleg_Troyansky — Tue, 25 Aug 2015 16:07:39 GMT

Hi Cassandra,

I think you might be overly complicating the issue. When any chart has a Group as a dimension, the current choice within the group can be replicated in two ways:

1. If another chart (or even a list box) uses the same Cycle Group, it will automatically show the same selected Dimension as the first group. In other words, Cycle Groups are global - when one chart shows Products, all charts with the same Group will show Products.

2. You can also use the function GetCurrentField() in order to use the name of the currently selected field in an expression.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: Container and Cycle Selection

marcus_sommer — Tue, 25 Aug 2015 16:12:32 GMT

I get confused - is there only one object (which is in an container - why) and the issue is the cycling group?

- Marcus

Re: Container and Cycle Selection

cbaqir — Tue, 25 Aug 2015 16:29:15 GMT

There are two charts in the container... one that shows Level A and one that shows Level B.

There is also another chart not in the container with a group for cycling between Level A counts and Level B counts.

Re: Container and Cycle Selection

Tue, 25 Aug 2015 16:41:25 GMT

I believe with an application, wheter a small test or scrambled live one, we will all better understand

Re: Container and Cycle Selection

cbaqir — Tue, 25 Aug 2015 18:01:13 GMT

Oleg,

The cycle group is only on the bottom chart - not the charts within the container. I am working on a sample.

Re: Container and Cycle Selection

cbaqir — Tue, 25 Aug 2015 18:14:42 GMT

Please see attached sample.

Re: Container and Cycle Selection

Tue, 25 Aug 2015 18:24:01 GMT

thanks - do I understand that if you select the cycle group on the bottom that says Request_ID the chart in the container should show the Project View chart but if you select Program or Portfolio in the cycle group you want the Program & Portfolio view chart in the container to show?

Re: Container and Cycle Selection

cbaqir — Tue, 25 Aug 2015 18:25:27 GMT

I suppose it should work that way too but the initial request was if you pick Project view, the Cycle should show REQUEST_ID and if you pick the Program and Portfolio view, the Cycle should show Program and Portfolio.