topic Re: Selection not supported. in QlikView

Selection not supported.

Wed, 25 Nov 2020 16:16:04 GMT

Dear all,

Sum(Aggr(

If(Status = 'ACTIVE,

NetWorkDays(Date(Date#(LON_DATE)), Today()),

NetWorkDays(Date(Date#(LON_DATE)), Date(Date#(SET_DATE))))

, Dim1, Dim2))

This expression has been used in my application.

Results of the same does not changed according to the selection made in the selection box (Month and Year).

Rgds,

Priyantha.

avinashelite — Thu, 02 Feb 2017 07:41:00 GMT

Does the Month and Year are in the Aggr condition

Anonymous — Thu, 02 Feb 2017 07:51:27 GMT

Hi Priyantha,

If I am not wrong you are missing measure in the expression

Correct me if I am wrong

If(Status = 'ACTIVE,

NetWorkDays(Date(Date#(LON_DATE)), Today()),

NetWorkDays(Date(Date#(LON_DATE)), Date(Date#(SET_DATE))))

'MEASURE', Dim1, Dim2))

Tue, 07 Feb 2017 11:37:05 GMT

THX.