Set analysis on Selected list box values

[#1]

The following Set analysis expression does not filter at all.

What am I doing wrong?

Dimensions Field: =if([Week Number]>vMaxWeekMI-6,Date([Report Display Format],'DD - MMM'))

Expression Field conditions:

A=    =count({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2015}>}INCNumber)

B=    =count({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2016}>}INCNumber)

C =    =timestamp(Sum({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2016}>}[Incident Calculation]) / count({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2016}>}INCNumber),'hh:mm')

D =   =Sum({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2016}>}[Incident Calculation])

E =    =Sum({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"}>}{<Year={2015}>}[Incident Calculation])

Thanks

Sharma Rajendra

[MK_QSL]

Provide sample data or sample app to work...

[tresesco]

Syntax is not quite correct. Try removing few extra brackets like:

=count({<[Week Number] = {">=$(=Max([Week Number])-5)<=$(=Max([Week Number]))"} , Year={2015}>} INCNumber)

[hemanthaanichet · Accepted solution]

Hi Sharma,

Syntax is not correct. I did some edited works check once let me know.

A=    =count({<[Week Number] = {">=$(=Max([Week Number])-5) <=$(=Max([Week Number]))"},Year={2015}>} INCNumber)

B=    =count({<[Week Number] = {">=$(=Max([Week Number])-5) <=$(=Max([Week Number]))"} ,Year={2016}>} INCNumber)

C =    =timestamp(Sum({<[Week Number] = {">=$(=Max([Week Number])-5) <=$(=Max([Week Number]))"},Year={2016}>}[Incident Calculation]) / count({<[Week Number] = {">=$(=Max([Week Number])-5) <=$(=Max([Week Number]))"},Year={2016}>} INCNumber),'hh:mm')

D =   =Sum({<[Week Number] = {">=$(=Max([Week Number])-5) <=$(=Max([Week Number]))"},Year={2016}>}[Incident Calculation])

E =    =Sum({<[Week Number] = {">=$(=Max([Week Number])-5) <=$(=Max([Week Number]))"},Year={2015}>}[Incident Calculation])

Regards

Hemanth

[#5]

tresesco & Hemanth Thanks you very much for your help

Thanks

Sharma Rajendra