List box selection of min and max date

[manoranjan_d]

in a list box i have list of dates example

format;DD/MM/YYYY

date

1/1/2017

2/1/2017

3/1/2017

4/1/2017

5/1/2017

1. When the user do multi select in Date column, by enabling the condition consider the min(Date) selection as 1^st column in straight table and max(Date) column as second one for the same measures.

example1: in the list box if user do multi select in Date column like 3/1/2017 and 5/1/2017 means min is 3/1/2017 and max is 5/1/2017

so the first expression column in the straight table has to show the 3/1/2017 data and second column expression has to be 5/1/2017.

according to the multiple selection example2: if user select all the dates in the list box it should take only min and max of the there multiple selection.

pls provide your solutin in qvw file. attached file for your refernce

[balar025]

hi, please find updated file.

Regards,

Ravi

[manoranjan_d]

ravi,

in the expression you have used =sum({<[primary compare date]={'$(vMinDate)'}>}amount)?, so i don't want this expression means i have to use below expression?

=only({<[primary compare date]={'$(vMinDate)'}>}amount)?

[balar025]

hi monoranjan,

if you have one to one mapping value then you can go for Only function.

Regards,

Ravi

[Anonymous]

try below one

sum({<[primary compare date]={'>$(vMinDate)<=$(vmaxDate)'}>}amount)

[manoranjan_d]

Hi Ravi one more requirement

If the user select only one week selection in Comparison date – show only that week values, how to restrict the second column ?

[balar025]

that you can restrict by checking GetSelectedCount([primary compare date])<>1 in condition of second dimension.