Author Topic: Filter the Data in visualization by Date Interval In Active Reports  (Read 318 times)

Offline Pratap Reddy

  • Community Leader
  • *****
  • Join Date: Dec 2017
  • Posts: 116
  • Forum Citizenship: +0/-0
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.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,286
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
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.
Meep!

Offline Pratap Reddy

  • Community Leader
  • *****
  • Join Date: Dec 2017
  • Posts: 116
  • Forum Citizenship: +0/-0
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..

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,286
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
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.
Meep!

Offline Pratap Reddy

  • Community Leader
  • *****
  • Join Date: Dec 2017
  • Posts: 116
  • Forum Citizenship: +0/-0
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...

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,286
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
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.

Meep!

Offline Pratap Reddy

  • Community Leader
  • *****
  • Join Date: Dec 2017
  • Posts: 116
  • Forum Citizenship: +0/-0
Hi MFGF,

Thank you for your reply.

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

Thanks in Advance.

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,286
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
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.
Meep!

 


       
Twittear