Need to Show data after Aug-2016

[mhmmd_srf]

Hi All,

I have below requirements. I need to show no if inc count which came after Aug-2016 with other certain condition. Below is my expression:

Count({$<[Incident_Month_Year]={'>=2016-Aug'},inc_flag={'Closed'},inc_priority={'1'}>} distinct inc_number)

But in this case the KPI is static. Value is not changing with the selection of months. It is always showing 145.

Please suggest.

Thanks,
Sarif

[#2]

Hi Sharif,

Check the date format and some times it will make problem..

Convert into number format and try...but above expression correct...

[rupamjyotidas]

You have hard coded the values, The values are not going to change in Date selection. Its always going to be 2016-Aug

[Incident_Month_Year]={'>=2016-Aug'}

Going by what information you have provided, you wanted only to show values where Incident Month Year > Aug 2016.

[mhmmd_srf]

yes..but what would be the solution?

[MK9885]

Count({$<[Incident_Month_Year] = {">=$(=date(monthstart([Incident_Month_Year]), 'MMM-YYYY'))",,inc_flag={'Closed'},inc_priority={'1'}>} distinct inc_number

Also check your Date format, is it MMM-YYYY or something else?

[mhmmd_srf]

how this is restricting data till Aug-2016?

[MK9885]

sorry I thought something else, can you share your qvw?

[rupamjyotidas]

What selection you want it to work on. What is the requirement. KPI should show after Aug 2016?