Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

set expression

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)

1 Solution

Accepted Solutions
sunny_talwar

Try creating it like this:

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

View solution in original post

5 Replies
Frank_Hartmann
Master II
Master II

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
Creator II
Creator II
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

Try creating it like this:

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

upaliwije
Creator II
Creator II
Author

Thanks all