Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

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.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Getselectedcount issue.

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
Highlighted
MVP
MVP

Re: Getselectedcount issue.

Highlighted
MVP
MVP

Re: Getselectedcount issue.

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

Highlighted
Partner
Partner

Re: Getselectedcount issue.

Try below expression:


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