eliminate the duplicate the in stright table

[#1]

Hi

  i use  two calender  b/w  the range  but  expression not  working,dupicates coming

[Gysbert_Wassenaar]

I don't know what you're trying to do. Your calendar objects are not used to make selections, so all dates are shown in your straight table. Is that what you want to change? See attached qvw for how to make that work (look at the Variable Event Triggers).

You mention duplicates. Can you explain what you mean? I don't see any duplicate records in the screenshot of your straight table.

The expression

     =Count(DISTINCT if( BUDAT>= $(Vstart Date) AND BUDAT <= $(VEndDate), MANDT))

can be rewritten as

     =Count({<BUDAT={">= $(Vstart Date)<= $(VEndDate)"} >} DISTINCT MANDT)

[#3]

thank for uer  reply

i create the two  calender starting  date and ending  date    depending on the selection   the  data  should be shown ,