Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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

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

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

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