topic Re: Conditional visibility of Chart in Container in QlikView

Conditional visibility of Chart in Container

Fri, 04 Apr 2014 11:38:07 GMT

Hi All,

I have a list box with four elements and a container with three charts I want to make third chart will be visible only when fourth element is selected from the list box.

Is there any way to do this without using layering.

Thanks in advance.

Reg,

Prakash

Re: Conditional visibility of Chart in Container

its_anandrjs — Fri, 04 Apr 2014 11:40:26 GMT

Try to use

=GetFieldSelections(FieldName) = Fieldvalue in the properties -> layout of the 3 chart

Eg:-

Suppose your column is

Region

Then select D

=GetFieldSelections(FieldName) = 'D'

Write this code in the 3rd chart layout properties

Re: Conditional visibility of Chart in Container

Fri, 04 Apr 2014 11:42:35 GMT

Hi,

For the third chart use the conditional expression in layout like

=If(GetfieldSelections(ListboxColumn)='4thvalue',1,0)

Re: Conditional visibility of Chart in Container

Fri, 04 Apr 2014 11:55:07 GMT

Hi Anand Chauhan,Ravi Kumar

I have tried using this but problem here I am getting is, chart is hide now but tab is still visible in the container

Thanks,

Prakash

Re: Re: Conditional visibility of Chart in Container

Fri, 04 Apr 2014 12:06:42 GMT

First possibility is using Grid style

Second one is using 2 containers

one with 3 charts (hide when 4th item is selected else enable)

and one with 2 charts (hide when 4th item is not selected else enable)

Re: Conditional visibility of Chart in Container

VishalWaghole — Fri, 04 Apr 2014 12:21:44 GMT

Hi Prakash,

If possible then dont use container, use the separate charts and arranged as it shows like container,

it will help you for conditionaly hide charts with tab.

for that you can use GetfieldSelections() function or you can declare any variable.

Hope you will understand.

- Regards,

Vishal Waghole

Re: Conditional visibility of Chart in Container

its_anandrjs — Fri, 04 Apr 2014 12:28:38 GMT

Hi Prakash,

If it is not necessary don't use chart in the container another way is used another container with chart for hide the 3rd chart.

Thanks & Regards

Re: Conditional visibility of Chart in Container

Fri, 04 Apr 2014 12:43:45 GMT

Thanks Friends it's working now by layering.

VishalWaghole
The problem using buttons/text instead of container is container's buttons take size along with chart but if we hide third chart along with button/text for that chart it will tedious to map size of buttons/texts

Thanks,

Prakash

Re: Conditional visibility of Chart in Container

VishalWaghole — Fri, 04 Apr 2014 12:48:38 GMT

Great job and Gud luck dear...

- Regards,

Vishal Waghole

Re: Conditional visibility of Chart in Container

Fri, 04 Apr 2014 12:51:28 GMT

Thanks Vishal