topic Re: conditional selection in field in QlikView

conditional selection in field

Anonymous — Sun, 01 Apr 2018 11:38:03 GMT

Hi guys,

I have a selection field that calld "DEPARTMENT_DESC"

I have another field called "TEAM_DESC"

Is it possible to show only connected teams when ccertain is selected?

I have tryed this formula with no luck....:
=IF(GetFieldSelections(DEPARTMENT_DESC)='inland', Only({<DEPARTMENT_DESC={'inland'}>} TEAM_DESC),Only(TEAM_DESC))

thanks!

Re: conditional selection in field

sunny_talwar — Tue, 03 Apr 2018 15:53:20 GMT

May be this

Aggr(Only({1<DEPARTMENT_DESC = p(DEPARTMENT_DESC)>} TEAM_DESC), TEAM_DESC)

or this

Aggr(Only({1<DEPARTMENT_DESC = {'inland'}>} TEAM_DESC), TEAM_DESC)

or this

Aggr(If(GetFieldSelections(DEPARTMENT_DESC) = 'inland', Only({1<DEPARTMENT_DESC = {'inland'}>} TEAM_DESC), Only(TEAM_DESC)), TEAM_DESC)