Set Analysis

[#1]

Hi community

I have a problem with set analysis in a expression.

Actually I want to calculate the count of data field excluding the current week.Here is my expression.Field and data are dummy fields

Count({$<[Week Date]={"<$(#vCurrentWeek)"},[Field)]={'>10'}>}[Data])

vCurrentWeek= Date(Max([Week Date]),'DD.MM.YYYY')

For example vCurrentWeek will be 28.07.2013 considering the last sunday

any help will be appreciated.

[#2]

Try below...

Count({<[Week Date]={'<$(vCurrentWeek)'},Field={'>10'}>}[Data])

Regards-Bika

[#3]

Thanks Bika

But unfortunately it is not working.still chart is not displaying any data .If I remove Week Date filter in the expression it is working fine.Some problem with the Week Date.

My week date is in the formate DD.MM.YYYY

Is this creating any problem here?

Regards

Murali Krishna

[kaushiknsolanki]

HI,

     If you have done any selections then you must deselect them in set analysis.

     Say for example if you have selected Month and Year then your expression should be.

     Count({$<[Week Date]={"<$(#vCurrentWeek)"},[Field)]={'>10'},Month=,Year=,Week=>}[Data])

     Also make sure that the date format of the [Week Date] field and the Variable is same.

Regards,

Kaushik Solanki

[#5]

Try to change week date format DD.MM.YYYY   to DD/MM/YYYY.

hope it will help u

[#6]

try this

Count({$<[Week Date]={'<vCurrentWeek'},[Field)]={'>10'}>}[Data])

and check the format of [Week Date] and vCurrentWeek, both format should must be same

[#7]

No luck Bika

Still same problem.

[#8]

Still not working Vishwa