topic set expression in QlikView

set expression

upaliwije — Sun, 24 Jul 2016 13:49:56 GMT

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 — Sun, 24 Jul 2016 14:06:36 GMT

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 — Sun, 24 Jul 2016 14:08:51 GMT

Hi,

This field is connected to a master calender

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

Anil_Babu_Samineni — Sun, 24 Jul 2016 14:28:30 GMT

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 — Sun, 24 Jul 2016 15:41:37 GMT

Try creating it like this:

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

upaliwije — Mon, 25 Jul 2016 03:20:35 GMT

Thanks all