Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
sanjyotpatkar
Contributor III

Conditional Show of the values in the list box based on the sheet selected?

Hi

I need to only specific values in the list box filter based on the Sheet selected. All values in the list box need not appear if these are not pertinent to the tab. Is there a way to do a conditional show based on the sheet selected?

5 Replies
Highlighted
anushree1
Valued Contributor II

Re: Conditional Show of the values in the list box based on the sheet selected?

Hi,

Is this what you are looking for

Highlighted
effinty2112
Honored Contributor

Re: Conditional Show of the values in the list box based on the sheet selected?

Hi Sanjyot,

                         Add a listbox by left clicking on the screen and instead of selecting Select Fields ... , click New Sheet Object >> Text Box.

Instead of picking a field from the list go to the bottom of this list and select <Expression>. This will allow you to enter an expression that will define a calculated dimension.

This could be something as simple as an if statement such as:

=if([Product Group] = 'Shoe', [Product Code])

so if your sheet is all about shoes your list box will return the product code for shoes and not raincoats.

cheers

Andrew

sanjyotpatkar
Contributor III

Re: Conditional Show of the values in the list box based on the sheet selected?

Hi Andrew

I have tried this approach but doesnt seem to work .in the list box i chose expression and entered the below expression using if condition

=if(GetActiveSheetId()='SH01',Application ='ABC')

I need to show specific applications when a particular tab is selected.

Highlighted
effinty2112
Honored Contributor

Re: Conditional Show of the values in the list box based on the sheet selected?

Try:

=if(GetActiveSheetId()='Document\SH01',Application ='ABC')


When you look at your sheet properties tab it might say SH01 but place a textbox on the sheet with expression

=GetActiveSheetid()


Cheers


Andrew

Highlighted
sanjyotpatkar
Contributor III

Re: Conditional Show of the values in the list box based on the sheet selected?

Thanks..It worked to some extent but I am getting values 0,-1 in the list box. My expression for the list box is as below

=if(wildmatch(GetActiveSheetId(),'Document\SH01'),Application ='Erwin')

I get 2 values in the list box i.e. 0 and -1. When I select 0 table show all values other than 'Erwin' and when i click on -1 in the listbox it gives me the selection by Erwin