COGNOiSe.com - The IBM Cognos Community

I have an urgent requirement as follows:

I have a static choices value prompt which has values

Use value-1 display value-1 day
use value-2 display value-2 days
use value-3 display value-3 days
use value-4 display value-4 days
use value-5 display value-5 days


I have dateapplied column in the list report which is of character datatype. The requirement is if the use selects 1 day, date applied column whould display data of maximum date of that column..e.g if 8,9,10 are in that column, it should display 1 day latest one day data. here maximum date is 10th.

similarly if user seletc 2 days, it should display latest last 2 days data i..e 9th and 10th.

our data source is Excel.

Please help me in this. I am unable to do this


getting datatype conversion errors and also with maximum..please help me how to do. v urgent..

thanks in advance,
srinidhi

I'm not sure I completely understand, but it sounds like you might want to use rank instead of maximum. Then you can filter for the desired ranks based on the parameter.

Create a data item with a rank expression to see how it works. Once you get the proper expression you can apply a filter.

Hi Srinidhi,

As per my understanding, you can write a case statement in filter.

case(?Static_choice_Prompt?)
when '1' then (Date = max(date))
when '2' then ( Date between max(date) and (max(date)-1) )
when '3' then ( Date between max(date) and (max(date)-2) )
when '4' then ( Date between max(date) and (max(date)-3) )
.
.
.
end

I hope, this logic  helps you to resolve your issue. However, you need to take care of data types.

Thanks,
Venkat.A.H