Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try creating it like this:
Date(Date#(Dual(MONTH, fMonth) &'-'&Dual(YEAR, fYear), 'MMM-YYYY'), 'MMM-YYYY') as FMonth_Year,
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!
Hi,
This field is connected to a master calender
Dual(MONTH, fMonth) &'-'&Dual(YEAR, fYear)As FMonth_Year,
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
Try creating it like this:
Date(Date#(Dual(MONTH, fMonth) &'-'&Dual(YEAR, fYear), 'MMM-YYYY'), 'MMM-YYYY') as FMonth_Year,
Thanks all