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

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

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

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

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

MK_QSL — Mon, 15 May 2017 13:05:38 GMT

Use this

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

All other look ok

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

Anonymous — Mon, 15 May 2017 13:35:06 GMT

Presentaion- text in search

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

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

hcabrera — Mon, 15 May 2017 16:23:25 GMT

Hi,

may be,

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

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

Anil_Babu_Samineni — Mon, 15 May 2017 16:35:48 GMT

Or this?

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

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

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

Anonymous — Tue, 16 May 2017 12:36:43 GMT

This condition is working correctly as per my requirement:

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