topic Re: Getselectedcount issue. in QlikView

Getselectedcount issue.

rdsuperlike — Fri, 13 Jan 2017 18:43:07 GMT

I want the text box to show only the result that user selects out of the 3 dropdowns, Finance,Rollup,DH.

Right now the below formulae shows all the results that come up and are connected when user selcts one dropdown.

eg: If user selects Finance = "abc", then since bcz of associtivity Rollup = "xyz" and DH = "wdf" also gets printed on the text box. Another user can select Rollup = "xyz. Basically in textbox I want to select the green value, i.e the one selected out of the above 3 dropdowns

Formulae:

if(GetSelectedCount([Finance])=0 and GetSelectedCount([Rollup])=0 and GetSelectedCount([DH])=0, 'Overall View', [Finance] & [Rollup ] & [DH])

Any help is appreciated.

Thanks.

Re: Getselectedcount issue.

MK_QSL — Fri, 13 Jan 2017 18:45:05 GMT

Field Functions

Re: Getselectedcount issue.

johnw — Fri, 13 Jan 2017 19:00:50 GMT

I may not have understood, but maybe this?

if(GetSelectedCount([Finance]),[Finance]
,if(GetSelectedCount([Rollup]),[Rollup]
,if(GetSelectedCount([DH]),[DH],'Overall View')))

Re: Getselectedcount issue.

krishnacbe — Fri, 13 Jan 2017 19:27:39 GMT

Try below expression:

if(GetSelectedCount([Finance])=0 and GetSelectedCount([Rollup])=0 and GetSelectedCount([DH])=0, 'Overall View', GetFieldSelections([Finance]) & GetFieldSelections( [Rollup ]) & GetFieldSelections([DH]))