I have written following set expression. But it is not working. Can you pls look at it rectify if I m wrong
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!
This field is connected to a master calender
Dual(MONTH, fMonth) &'-'&Dual(YEAR, fYear)As FMonth_Year,
Try creating it like this:
Date(Date#(Dual(MONTH, fMonth) &'-'&Dual(YEAR, fYear), 'MMM-YYYY'), 'MMM-YYYY') as FMonth_Year,
Use this for monthyear
Month(datefield) & '-' & year(datefield) as fmonthyear
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
Retrieving data ...