topic Set analysis on Selected list box values in QlikView

Set analysis on Selected list box values

Sun, 06 Nov 2016 04:49:21 GMT

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

Re: Set analysis on Selected list box values

MK_QSL — Mon, 07 Nov 2016 08:49:00 GMT

Provide sample data or sample app to work...

Re: Set analysis on Selected list box values

tresB — Mon, 07 Nov 2016 09:35:50 GMT

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

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

Re: Set analysis on Selected list box values

hemanthaanichet — Mon, 07 Nov 2016 09:50:59 GMT

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

Re: Set analysis on Selected list box values

Tue, 08 Nov 2016 00:05:59 GMT

tresesco & Hemanth Thanks you very much for your help

Thanks

Sharma Rajendra