set analysis

[#1]

Hi to all,

I have my data with start date is 01/12/2008.

if i  select at date 2/2/2014 in List box,i want display the data from 01/12/2008 to 2/2/2014.   [in pivot table]

Please suggest me..

Thanks in Advance

chandra.

[alexandros17]

In your pivot table add to all your expressions a set analysis, somthing like:

Sum({$ < myDate={'$(=GetFieldSelections(myDate))'}> } Values)

let me know

[maxgro]

date is your date

val is the expression

sum({$ <date={"<=$(=max(date))"}>} val)

[#4]

Hi

Thanks for your reply.

But i Want to get the data from starting date  to selected date.

suggest me pls

Thanks

[alexandros17]

Does it works this ?

Sum({$ < myDate={'<=$(=GetFieldSelections(myDate))'}> } Values)

[maxgro]

see attachment

[#7]

Hi

not working Saccone

Thanks

[chematos]

Hi,

I recommend you to create a table only with date fields, unlinked to the model, a DataIsland, e.g. if you have a Calnedar table with a date filed (Date) and a date field with number format (NumDate), I recommend to use number format to compare dates:

Qualify *;

Dates:

Load distinct Date,

     NumDate

from Calendar;

Unqualify *;

Remind to have the same date format in both tables, then you can use Dates.Date as the date filter in your dashboard and use something like this in your chart:

Sum({<NumDate={<=Dates.NumDate}> } data)

Please. review the syntaxis.

Regards,

Jose