topic Re: Display chart based on a value from the selction box in QlikView

Display chart based on a value from the selction box

shamitshah — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want the chart only to appear based on a selection from the list box.

For example list box called Project with values 11,12,13

I want the chart hidden and only appear on the selection of either 11,12,13

I tried the GetFieldSelections(Project)='*' in Chart Properties ->Layout -> Conditional but does not seem to work

Any ideas?

Re: Display chart based on a value from the selction box

Anonymous — Wed, 22 Aug 2018 02:49:21 GMT

Hi Shamit,

Kindly try it

Project = '11' or Project = '12' or Project = '13' in in Chart Properties ->Layout -> Conditional

Thanks

Re: Display chart based on a value from the selction box

tamilarasu — Wed, 22 Aug 2018 03:32:28 GMT

Hi Shamit,

=Wildmatch(GetFieldSelections(Project),'11','12','13')>0

Re: Display chart based on a value from the selction box

shamitshah — Wed, 22 Aug 2018 03:46:26 GMT

How about where I have quite a huge number of Projects to chose from? I have only included 3 project numbers in the example above. In reality, there will be more.

Thanks

Shamit

Re: Display chart based on a value from the selction box

tamilarasu — Wed, 22 Aug 2018 03:52:35 GMT

Just a quick question. You want to display the chart if there is only one selection (not multiple) in the listbox. Am I right?

If yes, then try like

=GetSelectedCount(Project)=1

Re: Display chart based on a value from the selction box

shamitshah — Wed, 22 Aug 2018 04:00:31 GMT

Hi Tamil,

Either one or multiple selections (i.e. both).

I am not sure what syntax I should use to capture all the projects in x below

=Wildmatch(GetFieldSelections(Project),x)

Thanks

Re: Display chart based on a value from the selction box

tamilarasu — Wed, 22 Aug 2018 04:09:20 GMT

How about this?

=GetSelectedCount(Project)>0

Re: Display chart based on a value from the selction box

shamitshah — Wed, 22 Aug 2018 04:44:49 GMT

I tried that, but it does not hide the table initially.

Is there anything else I need to do to hide the table?

Re: Display chart based on a value from the selction box

tamilarasu — Wed, 22 Aug 2018 04:53:41 GMT

Shamit - It nothing is selected in the "Project" field, it will automatically hide the chart. Have a look at the attached file.

Re: Display chart based on a value from the selction box

tresB — Wed, 22 Aug 2018 04:55:56 GMT

You used GetFieldSelections(). Try using GetSelectedCount()

Re: Display chart based on a value from the selction box

tamilarasu — Wed, 22 Aug 2018 05:05:14 GMT

I missed to check the screenshot.

Re: Display chart based on a value from the selction box

shamitshah — Wed, 22 Aug 2018 05:13:49 GMT

Thanks Guys!

Re: Display chart based on a value from the selction box

shamitshah — Wed, 22 Aug 2018 05:30:08 GMT

Hi Tresesco,

I note that GetSelectedCount() works fine with one dimension within (). How do I bring in additional dimensions?

Thanks

Re: Display chart based on a value from the selction box

tresB — Wed, 22 Aug 2018 05:37:53 GMT

Then use : =Len(GetCurrentSelections())>0

Re: Display chart based on a value from the selction box

shamitshah — Wed, 22 Aug 2018 22:58:56 GMT

Thanks Tresesco,

That works fine.