Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

upaliwije
Contributor II

Expression

Dear Friends

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'))

 

2 Replies
upaliwije
Contributor II

Re: Expression

Sorry.  I seek your help to get my expression corrected

michael_holzing
New Contributor

Re: Expression

Hi,

I think your field VFROM isn't a Date format. You have to turn your Dimension VFROM to a Date Format work with the operator ">=".
In your script, try the makedate function like this: MakeDate(Year(POL_PERIOD_FROM),Month(POL_PERIOD_FROM),'01') as VFROM

Cheers