topic Re: Set Analysis syntax error in QlikView

Set Analysis syntax error

prma7799 — Fri, 23 Mar 2018 06:58:36 GMT

Hi All,

I am getting syntax error and also not getting sum of quantity for that expression.

PFA...

tresB — Fri, 23 Mar 2018 07:10:19 GMT

What would be the date condition, could you explain in words?

prma7799 — Fri, 23 Mar 2018 07:14:32 GMT

I have written this code

=sum({<[Expiration Date]={"<=$(=today())>01/01/1753"} [Remaining Quantity])

but i am not getting sum qty less than today date and i dont want to consider QTY for 01/01/1753 date

chinnuchinni — Fri, 23 Mar 2018 07:19:14 GMT

try with this:

=sum({<[Expiration Date]= {'>$(=date(01/01/1753,'DD/MM/YYYY'))<=$(=max([Expiration Date]))'}>}[Remaining Quantity])

tresB — Fri, 23 Mar 2018 07:21:25 GMT

Try formatting the timestamps similar to the date field like:

=sum({<[Expiration Date]={"<=$(=timestamp(today(),'MM/DD/YYYY hh:mm:mm TT')) >01/01/1753 00:00:00 PM"}>} [Remaining Quantity])

prma7799 — Fri, 23 Mar 2018 07:35:14 GMT

when i using you expression in my production application then it is coming 0 value

i have used this

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';

tresB — Fri, 23 Mar 2018 07:37:11 GMT

How do the values in [Expiration Date] field look like in prod?

prma7799 — Fri, 23 Mar 2018 07:40:03 GMT

When i use below then it is working fine

=sum({<[Expiration Date]={"<=$(=timestamp(today(),'DD/MM/YYYY hh:mm:mm')) >01/01/1753 00:00:00 PM"}>} RemainingQuantity)

Expiration Date look like below

tresB — Fri, 23 Mar 2018 07:53:28 GMT

The field format and the comparison parameters have to match. You should also, remove 'PM' from the last value part.