Qlikview have 2 fields in search box,want text box visible when either one of the field is selected

[Anonymous]

Hi Team

I have a search box which contains 2 fields: Country and Sales.I have a requirement, when user selects either Country/ Sales the text box "Hello Country/Sales is selected" should be visible. When nothing is selected text box "Hello" should be visible.

PFA qvw.

Please help

Thanks

[MK_QSL]

Use this

='Hello ' & Country & ' : ' & SUM(Sales) & ' is selected'

All other look ok

[Anonymous]

Presentaion- text in search

= if(GetFieldSelections(Country)=Country ,'Hello Country/Sales is selected','Hello')

[hcabrera]

Hi,

may be,

=if(GetFieldSelections(Country)=Country or GetFieldSelections(Sales)=Sales,'Hello Country/Sales is selected','Hello')

[Anil_Babu_Samineni]

Or this?

='Hello ' & Country & ' : ' & Concat(Sales,',') & ' is selected'

Or

='Hello ' & Country & ' : ' & If(GetFieldSelections(Sales)>0, Sales, ' ') & ' is selected'

[Anonymous · Accepted solution]

This condition is working correctly as per my requirement:

GetSelectedCount(Country)=0 and GetSelectedCount(Sales)=0 in "Hello First Page"