topic PB dimension with differents date in QlikView

PB dimension with differents date

Fri, 02 Mar 2012 09:52:22 GMT

Hello,

i have a problem with a request from a client.

I expose the subject :

I ve some OW (orders works) which have a date of creation ( Date_cre), a date of start (Date_st) and a date of end (Date_end).

The Date_cre is relied on date of my calendar Date dimension.

I try to have one indicator by period and i don't succed :

1) the number of OW during a period (date) which have a Date_st is on the period selected, and a date_crea(=date) wich dhould take all the values possible.

The problem with this request is that i would like to have also the OW which has been creating before the period selected but it s a porblem besause i t s my dimension date=date_cre(ating).

So i build a table with period in dimension and i put this formular :

sum(${ <Date_cre={'>=$($min(Date)) <=$(=(max(Date))),

Date=

}

but i doesn t work and i can't change the date_st as the new dimesion date.

i m not sure to be clear but if you have any idea to resolve this problem.

Thanks

Pierre

PB dimension with differents date

CELAMBARASAN — Fri, 02 Mar 2012 10:24:19 GMT

Hi,

Try this expression

sum({ <Date_cre={">=$(=min(Date))<=$(=max(Date))"},Date=>} Sales)

Is this you have tried before?

Celambarasan

PB dimension with differents date

Fri, 02 Mar 2012 13:34:37 GMT

hello Celambarasan,

thank for your answer but it doesn't work

the result of this expression is the same that i wrote before.

This expression doesn't give the OW or sales which have a Date_cre ( Date ) different of the Date concerned by the period.

Pierre

PB dimension with differents date

Wed, 07 Mar 2012 15:34:50 GMT

hello,

is there any body who have a solution to resolve this probleme of dates with the set anlysis?

Maybe do i change my script and create an other table?

thanks