Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Format of CaStartDate should match '18-9-2014 0:00:00'
=max({<CaStartDate={"<='18-9-2014 0:00:00'"}, AgeCategory=>})
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)
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
Can you upload sample app
Hi, anbu,
I attached the file. Thanks very much~
Not able to open attachment. Can you reupload
hi
if you want to use a fixed set then you dont need the $ sign
have a look at the attach file
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
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)