topic Re: Expression in QlikView

Expression

upaliwije — Thu, 25 Aug 2016 05:01:59 GMT

Hi,

My following expression is not working.

SUM({<PAID_Month_Year={"<=Jul-2016"}>}PREMIUM)

Pls advise me where I am wrong

Re: Expression

avinashelite — Thu, 25 Aug 2016 05:04:24 GMT

Did you check the format of PAID_Month_Year? is MMM-YYYY

Re: Expression

tresB — Thu, 25 Aug 2016 05:06:50 GMT

It could be your PAID_Month_Year field format. How did you create the field in the script? If you use string functions to create it, set would not be to compare it like <=/ >= the way you want. You have to possible create a dual field in the script to use it in the set expression like you want.

Re: Expression

upaliwije — Thu, 25 Aug 2016 05:25:33 GMT

yes

It is like this

Jan-2016

Jul-2013

Jul-2014

Jul-2015

Jul-2016

Jun-2013

Re: Expression

upaliwije — Thu, 25 Aug 2016 05:26:31 GMT

my script is as blow

Month(PAID_DATE) &'-'& YEAR(PAID_DATE) As PAID_Month_Year,

Re: Expression

Chanty4u — Thu, 25 Aug 2016 05:29:03 GMT

try this

MakeDate(year(PAID_DATE),month(PAID_DATE)) as Paid_Month_Year

Re: Expression

tresB — Thu, 25 Aug 2016 05:59:10 GMT

Try it like:

Load

Dual(PAID_Month_Year, MakeDate(Year(PAID_DATE), Month(PAID_DATE))) as PAID_Month_Year ;

Load

Month(PAID_DATE) &'-'& YEAR(PAID_DATE) As PAID_Month_Year,

Re: Expression

tresB — Thu, 25 Aug 2016 07:03:04 GMT

Also, be careful when writing the set expression. You have to mention the the default date format like:

SUM({<PAID_Month_Year={"<=$(=Date(Date#('Jul-2016','MMM-YYYY'),'DD/MM/YYYY'))"}>}PREMIUM)

Note: the highlighted format might be different for your case.

Please also refer the attached qvw for better understanding.

Re: Expression

Anil_Babu_Samineni — Thu, 25 Aug 2016 08:50:45 GMT

Still not Resolved please post sample?

Re: Expression

teiswamsler — Thu, 25 Aug 2016 09:13:01 GMT

Hi Upali

Consider using numeric date formats in expression when >=<

ex.

YYYYMM or YYYYMMDD

/Teis