COGNOiSe.com - The IBM Cognos Community

Hi,

I have a Requirement where i need to filter data in visualization by date interval in Active reports

Concept:

Year >= 2010 and Year <= 2012

with above year inputs visualization need to filter..


Please find the attachment.

Quote from: Pratap Reddy on 04 Jan 2018 04:09:19 AM
Hi,

I have a Requirement where i need to filter data in visualization by date interval in Active reports

Concept:

Year >= 2010 and Year <= 2012

with above year inputs visualization need to filter..


Please find the attachment.

Hi,

So what are you struggling with? The attachment you posted doesn't explain to us what the issue is.

The approach is to use a control that allows multi-select (eg data toggle button bar, data list box, data discrete values slider etc) and populate a variable with this, then use the variable to filter your visualization.

Cheers!

MF.

Hi MFGF,

i have used two Data Discrete values Slider and List
i have used year data item for both Data Discrete Values Slider and values in year are 2010,2011,2012,2013
First Data Discrete values Slider i'm giving 2011
Second Data Discrete values Slider i'm giving 2013
i should get the result in List between 2011 and 2013
but it's getting First Discrete values slider values in List

Could you please give me a example if possible...


Thanks in Advance..

Quote from: Pratap Reddy on 05 Jan 2018 12:48:26 AM
Hi MFGF,

i have used two Data Discrete values Slider and List
i have used year data item for both Data Discrete Values Slider and values in year are 2010,2011,2012,2013
First Data Discrete values Slider i'm giving 2011
Second Data Discrete values Slider i'm giving 2013
i should get the result in List between 2011 and 2013
but it's getting First Discrete values slider values in List

Could you please give me a example if possible...


Thanks in Advance..

Hi,

You only need one Data Discrete Values slider. It has a "Range Type" property, and you need to set this to "Range" so that your slider will allow you to select a range of years.

See attachment...

Cheers!

MF.

Thanks a ton MFGF, its working good.

In Trail Version we have only four Inputs(2010,2011,2012,2013)

In my Project i have number of inputs like (1/1/2013,2/3/2013.........soon) or Calendar(1/1/2013 ...........1/1/2018)

How can i use range for above type of dates....

Thanks in Advance...

Quote from: Pratap Reddy on 05 Jan 2018 04:02:12 AM
Thanks a ton MFGF, its working good.

In Trail Version we have only four Inputs(2010,2011,2012,2013)

In my Project i have number of inputs like (1/1/2013,2/3/2013.........soon) or Calendar(1/1/2013 ...........1/1/2018)

How can i use range for above type of dates....

Thanks in Advance...

Do you want to use just the years from the dates, or do you want the dates themselves? If you just want to use the years, create a query calculation with the expression extract( year, [your Date item])

Cheers!

MF.

Hi MFGF,

Thank you for your reply.

Actually entire date i need to search in calendar data item.

Thanks in Advance.

Quote from: Pratap Reddy on 09 Jan 2018 05:05:03 AM
Hi MFGF,

Thank you for your reply.

Actually entire date i need to search in calendar data item.

Thanks in Advance.

There is no calendar object within an active report. The best you can do is a data discrete values slider, but it can look a bit messy.

Cheers!

MF.