aggr and set analysis help

[fdelacal]

i have this formula that works great.

=num(sum(aggr(count(distinct FEC),CTNO))

,FormatoNum)

now i need to put set analysis with a variable that selecet a specific day.

vDONE= date(max(BILL))

please help how can i do this?

[IAMDV · Accepted solution]

Something like this?

Num(sum(aggr(count({<date = {$(vDONE)}>} distinct FEC),CTNO)) ,FormatoNum)

Cheers,

DV

www.QlikShare.com

[fdelacal]

I don´t know why but it not working,

Thanks for your reply!!

Regards.

[Gysbert_Wassenaar]

Define your variable as =date(max(BILL)) so the max date is calculated outside the context of the chart. Also replace date in <date = {$(vDONE)}> with the name of your date field and make sure that the max date calculated in your variable has the same date format.

[fdelacal]

to be exacly  is

=num(sum(aggr(count(distinct BILL),CTNO))

,FormatoNum)

now i need to put set analysis with a variable that selecet a specific day.

vDONE= date(max(BILL))

so it will be

Num(sum(aggr(count({<BILL= {$(vDONE)}>} distinct BILL),CTNO)) ,FormatoNum)

that´s my actually formula than not work

[fdelacal]

Deepak Vadithala Thaths right. (   "    )  was the problem!!

regards.

=Num(sum(aggr(count({<FEC= {"$(vDONE)"}>} distinct FEC),CTNO)) ,FormatoNum)

[IAMDV]

Ah!!

Quote..."Quotes are my enemy"...Unquote.

I'm glad you got it working.

Cheers,

DV

www.QlikShare.com