topic Re: Variable Value not Displayed in Text Box in App Development

Variable Value not Displayed in Text Box

bbergstrom — Tue, 21 Dec 2021 22:06:32 GMT

In Qlik Sense I have a variable that contains the following:

$(vDateTo) -
If(GetSelectedCount(TimeframeFilterDate)=1,
If(GetFieldSelections(TimeframeFilterDate)='Previous week','$(vfDatePreviousWeekStart)',
If(GetFieldSelections(TimeframeFilterDate)='Previous month','$(vfDatePreviousMonthStart)',
If(GetFieldSelections(TimeframeFilterDate)='Previous 90 days','$(vfDatePrevious90DaysStart)',
If(GetFieldSelections(TimeframeFilterDate)='Previous 6 months','$(vfDatePrevious6MonthStart)',
If(GetFieldSelections(TimeframeFilterDate)='Previous 12 months','$(vfDatePrevious12MonthStart)'))))),
If('$(vFilterCheck)'='None',Date(Today()-32),Date(Min(DD_Date))))

If I put the above directly into a text box it works correctly. If I create a variable with the above and only include the variable in a text box it still works correctly. When I try to include it in an IF statement in the text box then it stops working:

If(GetSelectedCount(TimeframeFilterDate)=0,$(vDateTo))

The above returns a blank text box.

Re: Variable Value not Displayed in Text Box

Lauri — Fri, 07 Jun 2019 18:25:29 GMT

It looks like your If statement contradicts your variable, which only works when 1 selection of TimeframeFilterDate has been made.

Re: Variable Value not Displayed in Text Box

dplr-rn — Fri, 07 Jun 2019 18:48:22 GMT

change if condition to
f(GetSelectedCount(TimeframeFilterDate)=1,$(vDateTo))

Re: Variable Value not Displayed in Text Box

Channa — Sat, 08 Jun 2019 00:05:58 GMT

why u have count "0'

If(GetSelectedCount(TimeframeFilterDate)=0,(=vDateTo))

try this

Re: Variable Value not Displayed in Text Box

bbergstrom — Fri, 26 Jul 2019 13:10:22 GMT

Ended up having to do two things to make this work.

1) I created a new variable called $(vDateToTable) that was just =$(vDateTo)

2) When I inserted the variable into the text box I slapped quotes around it: '$(vDateToTable)'