Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

set expression

I have following 

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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

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


talk is cheap, supply exceeds demand
upaliwije
Creator II
Creator II
Author

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

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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


talk is cheap, supply exceeds demand