topic Re: Expression using both Input Box and set variables in QlikView

Expression using both Input Box and set variables

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have a Pivot Table in which I have a field to calculate the number of working days using a NetWorkDays expression. Now my client asked me to make some modifications to that table so that she has the option to input the end day in the NetWorkDays function. I've added a variable called vCustomEndDate which I can modify in an Input Box. Now when it comes to the expression I'm trying to branch it via an If(something like If(vCustomEndDate is not null, NetWorkDays(start_date,vCustomEndDate,$Holidays),NetWorkDays(start_date,end_date,$Holidays))).
Now my question is:How can I validate whether vCustomEndDate is null or not? I've tried If(vCustomEndDate -= {"=Null()"},NetWorkDays(start_date,vCustomEndDate,$Holidays),NetWorkDays(start_date,end_date,$Holidays))), but I got some errors.

Re: Expression using both Input Box and set variables

BalaBhaskar_Qlik — Fri, 27 Jul 2018 11:25:03 GMT

Check this:

User can enter data from Dashboard.

https://ap-a.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs%2FAsset%20Management.qvw&host=demo11&anonymous=true

Re: Expression using both Input Box and set variables

sunny_talwar — Fri, 27 Jul 2018 11:28:16 GMT

May be this

If(Len(Trim(vCustomEndDate)) > 0, NetWorkDays(start_date, vCustomEndDate, $Holidays), NetWorkDays(start_date, end_date, $Holidays)))

Re: Expression using both Input Box and set variables

BalaBhaskar_Qlik — Fri, 27 Jul 2018 11:31:43 GMT

May be these:

If(IsNull($(vCustomEndDate)),

NetWorkDays(start_date,$(vCustomEndDate),$Holidays),

NetWorkDays(start_date,end_date,$Holidays))),

If(Len(Trim($(vCustomEndDate))) = 0 or $(vCustomEndDate) = ' ',

NetWorkDays(start_date,$(vCustomEndDate),$Holidays),

NetWorkDays(start_date,end_date,$Holidays))),