topic Re: set expression in QlikView

set expression

upaliwije — Fri, 14 Dec 2018 07:08:43 GMT

I have following

Re: set expression

Gysbert_Wassenaar — Fri, 14 Dec 2018 07:16:34 GMT

You don't seem to have much of a following.

Do you at least have a question you want help with?

Re: set expression

upaliwije — Fri, 14 Dec 2018 07:48:20 GMT

Very Sorry I accidentally posted halfway through the writing. This is my issue

I have following set expression which does not return a value

sum({<VFROM={">=$(v1)"}>}PREMIUM)

VFROM=DEC-2017 ( a field created while loading data) Month(POL_PERIOD_FROM)&'-'&Year(POL_PERIOD_FROM)AS VFROM

v1= =DEC-2017 a vraiable (Let v1=Date(Makedate(2017,12,01),'MMM-YYYY'))

I seek your help to get my expression corrected

Re: set expression

Gysbert_Wassenaar — Fri, 14 Dec 2018 09:05:57 GMT

You create your VFROM as a text string value and then use the >= comparison operator to compare that with a date value. I think that's your problem. If you create VFROM as a date value it'll probably work

Date(POL_PERIOD_FROM,'MMM-YYYY')AS VFROM