topic Re: Add filter from expression in QlikView

Add filter from expression

ttal7878 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Is it possible to add this expression into list box,

so the user will have the option to select 'Yes'/'No' filter?

=if(sum({<PendingsPayments.unique_num= P({<cctranzresponse={'000'},Age={0},Calendar_TRX.Calendar_Date,Calendar_TRX.Day,Calendar_TRX.Month,Calendar_TRX.Year>}PendingsPayments.unique_num)>}PendingsPayments.unique_num)>1,'No',

if(sum({<PendingsPayments.unique_num= P({<cctranzresponse-={'000'},Age={0},Calendar_TRX.Calendar_Date,Calendar_TRX.Day,Calendar_TRX.Month,Calendar_TRX.Year>}PendingsPayments.unique_num)>}PendingsPayments.unique_num)>1,'yes'))

Re: Add filter from expression

Chanty4u — Mon, 31 Jul 2017 09:57:20 GMT

try to use aggr,

=aggr(if(sum({<PendingsPayments.unique_num= P({<cctranzresponse={'000'},Age={0},Calendar_TRX.Calendar_Date,Calendar_TRX.Day,Calendar_TRX.Month,Calendar_TRX.Year>}PendingsPayments.unique_num)>}PendingsPayments.unique_num)>1,'No',

Re: Add filter from expression

tresB — Mon, 31 Jul 2017 09:58:50 GMT

Yes. Only thing is, you have to use an aggr() like:

=Aggr( If(Sum(.....)), Dim1, Dim2,..)

Re: Add filter from expression

ttal7878 — Mon, 31 Jul 2017 10:24:14 GMT

Thank you!