Auto selected dates

[gidon500]

Hi guys

i have a rquest that i could not fulfil

enclosed is qvw file  with sales and date

the customers to select only one date from the list box

and get  all data from the min date , to the selected date .

can we make it

thanks

gidon

[kaushiknsolanki · Accepted solution]

Hi,

Make Straight Table and Put DOCDATE as dimension and

Sum({<DOCDATE = {"<=$(=Date(max(DOCDATE)))"}>}AMOUNT)

As expression.

Regards,

Kaushik Solanki

[vinieme12]

i Think this is enough as we'll be comparing with value from same field

Sum({<DOCDATE = {"<=$(=max(DOCDATE))"}>}AMOUNT)

[kaushiknsolanki]

Hi,

Its because the date format matters in set analysis.

Regards,

Kaushik Solanki

[gidon500]

thanks

gidon

[vinieme12]

Works in the above case