Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielco223
New Contributor III

Default Selection unless otherwise picked

Hi,

I am trying to get the below expression to default to Fiscal Year unless Fiscal Quarter Name Long or Fiscal - Period Name Year Short is selected in the filter pane. Below if the expression currently:

=if(GetSelectedCount([Fiscal - Year])>0,

if($(Surgical_Amount_Type)='Booked Amount',

if(GetSelectedCount([Fiscal - Year])>0,

$(aYearBookedToDate))

,$(aYearShippedToDate))

,

if(GetSelectedCount([Fiscal - Year Quarter Name Long])>0,

if($(Surgical_Amount_Type)='Booked Amount',

if(GetSelectedCount([Fiscal - Year Quarter Name Long])>0,

$(aQuarterBookedToDate))

,$(aQuarterShippedToDate))

,

if(GetSelectedCount([Fiscal - Period Name Year Short])>0,

if($(Surgical_Amount_Type)='Booked Amount',

if(GetSelectedCount([Fiscal - Period Name Year Short])>0,

$(aMonthBookedToDate))

,$(aMonthShippedToDate)))))

I tried to add "=" to the Fiscal Year to default it and that works for Fiscal Year but ignores the Fiscal - Year Quarter Name Long and Fiscal - Period Name Year Short when selected.

=if(GetSelectedCount([Fiscal - Year])=0,

if($(Surgical_Amount_Type)='Booked Amount',

if(GetSelectedCount([Fiscal - Year])=0,

$(aYearBookedToDate))

,$(aYearShippedToDate))

,

if(GetSelectedCount([Fiscal - Year Quarter Name Long])>0,

if($(Surgical_Amount_Type)='Booked Amount',

if(GetSelectedCount([Fiscal - Year Quarter Name Long])>0,

$(aQuarterBookedToDate))

,$(aQuarterShippedToDate))

,

if(GetSelectedCount([Fiscal - Period Name Year Short])>0,

if($(Surgical_Amount_Type)='Booked Amount',

if(GetSelectedCount([Fiscal - Period Name Year Short])>0,

$(aMonthBookedToDate))

,$(aMonthShippedToDate)))))

Any ideas how I can default it to the Fiscal Year expression but override that if the Fiscal - Year Quarter Name Long and Fiscal - Period Name Year Short is picked?

Community Browser