Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shamitshah
Partner - Creator
Partner - Creator

Display chart based on a value from the selction box

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?

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You used GetFieldSelections(). Try using GetSelectedCount()

View solution in original post

14 Replies
Anonymous
Not applicable

Hi Shamit,

Kindly try it

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


Thanks

tamilarasu
Champion
Champion

Hi Shamit,

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

shamitshah
Partner - Creator
Partner - Creator
Author

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

tamilarasu
Champion
Champion

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

shamitshah
Partner - Creator
Partner - Creator
Author

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

tamilarasu
Champion
Champion

How about this?

=GetSelectedCount(Project)>0

shamitshah
Partner - Creator
Partner - Creator
Author

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

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

tamilarasu
Champion
Champion

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

tresesco
MVP
MVP

You used GetFieldSelections(). Try using GetSelectedCount()