topic Re: aggr and set analysis help in QlikView

aggr and set analysis help

fdelacal — Wed, 03 Jul 2013 10:32:25 GMT

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?

Re: aggr and set analysis help

IAMDV — Wed, 03 Jul 2013 10:53:26 GMT

Something like this?

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

Cheers,

www.QlikShare.com

Re: aggr and set analysis help

fdelacal — Wed, 03 Jul 2013 11:08:00 GMT

I don´t know why but it not working,

Thanks for your reply!!

Regards.

Re: aggr and set analysis help

Gysbert_Wassenaar — Wed, 03 Jul 2013 11:45:03 GMT

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.

Re: aggr and set analysis help

fdelacal — Wed, 03 Jul 2013 13:26:11 GMT

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

Re: aggr and set analysis help

fdelacal — Wed, 03 Jul 2013 13:54:00 GMT

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

regards.

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

Re: aggr and set analysis help

IAMDV — Wed, 03 Jul 2013 13:59:43 GMT

Ah!!

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

I'm glad you got it working.

Cheers,