topic Re: problem with set analysis in QlikView

problem with set analysis

Anonymous — Mon, 24 Nov 2014 12:36:13 GMT

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

Re: problem with set analysis

anbu1984 — Mon, 24 Nov 2014 12:49:00 GMT

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

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

Re: problem with set analysis

ashwanin — Mon, 24 Nov 2014 12:52:57 GMT

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)

Re: problem with set analysis

Anonymous — Mon, 24 Nov 2014 13:10:07 GMT

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

Re: problem with set analysis

anbu1984 — Mon, 24 Nov 2014 13:12:40 GMT

Can you upload sample app

Re: problem with set analysis

Anonymous — Mon, 24 Nov 2014 14:19:31 GMT

Hi, anbu,

I attached the file. Thanks very much~

Re: problem with set analysis

anbu1984 — Mon, 24 Nov 2014 14:26:55 GMT

Not able to open attachment. Can you reupload

Re: problem with set analysis

lironbaram — Mon, 24 Nov 2014 14:37:04 GMT

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

have a look at the attach file

Re: problem with set analysis

sasikanth — Mon, 24 Nov 2014 14:41:18 GMT

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

Re: problem with set analysis

rubenmarin — Mon, 24 Nov 2014 14:41:19 GMT

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)

Re: problem with set analysis

Mon, 24 Nov 2014 14:56:47 GMT

Hi,

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

Re: problem with set analysis

Anonymous — Mon, 24 Nov 2014 15:29:14 GMT

Hi, Ruben,

Single quote is the trick here, thanks !!!