problem with set analysis

[Anonymous]

Hi, all,

I had a problem with the set analysis.

Originally, I have an expression like below, which works:

max({<CaStartDate={"<=$(=Date(today(),'D-M-YYYY h:mm:ss'))"}>}CaStartDate)

As I need to do test of the data, I need to fix a date, then I change the expression as follows:

max({<CaStartDate={"<=$('18-9-2014 0:00:00')"}>}CaStartDate)

And this one dose not work, it always give me the same result as  max(CaStartDate).

I learned from a college that this may caused by other current selections, so I add the AgeCategory which has a selection as below:

max({<CaStartDate={"<=$('18-9-2014 0:00:00')"}, AgeCategory=>}CaStartDate)

But it still dose not work.

Dose any one have a clue about this?

The example .qvw file is attached:

Thanks very much

[anbu1984]

Format of CaStartDate should match '18-9-2014 0:00:00'

=max({<CaStartDate={"<='18-9-2014 0:00:00'"}, AgeCategory=>})

[ashwanin]

You have used $ which is for variable dates.

Remove that if you want the static value.

=max({<CaStartDate={"<='18-9-2014 0:00:00'"}>} AgeCategory)

[Anonymous]

Hi, anbu, Ashwani,

Thanks for your quick answer. I tried without $:

max({<CaStartDate={"<='18-9-2014 0:00:00'"}, AgeCategory=>}CaStartDate),

but this even give no result, also no error info.

Zhihong

[anbu1984]

Can you upload sample app

[Anonymous]

Hi, anbu,

I attached the file. Thanks very much~

[anbu1984]

Not able to open attachment. Can you reupload

[lironbaram]

hi

if you want to  use a fixed set then you dont need the $ sign

have a look at the attach file

[sasikanth]

hi,

Probably because of dates types mismatch,

please check once weather the CaStartDate is same as the date format provided by you

in the expression

[rubenmarin · Accepted solution]

Hi, if max({<CaStartDate={"<=$(=Date(today(),'D-M-YYYY h:mm:ss'))"}>}CaStartDate) works, the dollar-expansion inserted will be:

max({<CaStartDate={"<=18-9-2014 0:00:00"}>}CaStartDate)