set expression

[upaliwije]

I have written following set expression. But it is not working. Can you pls look at it rectify if I m wrong

SUM({<DESCRIPTION={'GROSS_PREMIUM'},FMonth_Year={">=Jul-2015"}>}ACTUAL)

[Frank_Hartmann]

HI Upali,

can you give some more information?

Which format has FMonth_Year? Is it recognized by Qlikview as a num value or a string?

Is this field connected to a Mastercalendar?

Perhaps try to upload a sample which demonstrates the problem so its much easier to assist you!

[upaliwije]

Hi,

This field is connected to a master calender

   Dual(MONTH, fMonth) &'-'&Dual(YEAR, fYear)As FMonth_Year,

[Anil_Babu_Samineni]

Use this for monthyear

Month(datefield) & '-' & year(datefield) as fmonthyear

SUM({<DESCRIPTION={"GROSS_PREMIUM"},fmonthyear={">=Jul-2015"}>}ACTUAL)

I am not sure, but this expression getting the data for actual where gross premium add above of jul15

Or else send your application please

[sunny_talwar · Accepted solution]

Try creating it like this:

Date(Date#(Dual(MONTH, fMonth) &'-'&Dual(YEAR, fYear), 'MMM-YYYY'), 'MMM-YYYY') as FMonth_Year,

[upaliwije]

Thanks all