Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rdsuperlike
Creator
Creator

Getselectedcount issue.

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.

1 Solution

Accepted Solutions
johnw
Champion III
Champion III

I may not have understood, but maybe this?

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

View solution in original post

3 Replies
MK_QSL
MVP
MVP

johnw
Champion III
Champion III

I may not have understood, but maybe this?

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

krishnacbe
Partner - Specialist III
Partner - Specialist III

Try below expression:


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