How to add an expression using a date variable in the script

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

Hi Everyone, I'm new to QlikView and am having a little trouble modifying a report built by the previous person. We have an ad hoc report that allows the user to pick the dimension fields and the calculated fields displayed in the straight table. The calculated fields are defined in the script with an Expression table. What I trying to do is add a new calculated field that calculates DSO based on selections (start and end date) made in an input box. My problem is finding the correct syntax for the expression using the date variables (if that is even possible).

The user will select the desired dimensions and calculated fields the generate the report.

The expression is defined in the script using a Expression table:

The problem is when I add this expression the check box for DSO disappears from the List Box.

Round(Sum(if({<Ending Date = ('$(vEndDateRange)', EndingAmount,0))/Sum(if({Invoice Date > ('$(vStateDateRange)' and {Invoice Date} < ('$(vEndDateRange)', {Invoice Amount}, 0)) * (('$(vEndDateRange)'-('$(vStateDateRange)')

Does anyone have an idea how I can make this work?

Re: How to add an expression using a date variable in the script

ahmar811 — Fri, 24 Aug 2018 06:37:15 GMT

Create one variable for that expression like below

vExpression=MaxString(%Expression)

and use in table expression like below

$(vExpression)

Also find attached qvw file.

I hope this will help you.

Regards

Ahmar

Re: How to add an expression using a date variable in the script

ahmar811 — Fri, 24 Aug 2018 06:49:44 GMT

or second option for you is use direct expression like below into your chart expression

Expression =$(=maxstring(%Expression))

topic Re: How to add an expression using a date variable in the script in QlikView

How to add an expression using a date variable in the script

Re: How to add an expression using a date variable in the script

Re: How to add an expression using a date variable in the script