topic ignore selections using if Qlik Sense in App Development

ignore selections using if Qlik Sense

joeybird — Wed, 01 Aug 2018 08:53:43 GMT

Hi - Using Qlik Sense

I have been trying to ignore selections...there is a lot of columns in the data set...

I have tried to use the {1}, but the filters are still affecting the chart

here is the set analysis

sum({1<[WeekStartDate] = >}if([WeeksWaitedForOrder] + vWeekAdjust = Weeks,if([OrderInProgress] = 1,CurrentWeekIndicator,0),0))

please help

Gysbert_Wassenaar — Wed, 01 Aug 2018 09:12:40 GMT

What is the expression in vWeekAdjust?

joeybird — Wed, 01 Aug 2018 09:24:33 GMT

its a variable in the load , and to help with a rank functions used in other parts of the app

LET vWeekAdjust = ' =if(Min([TCIWeekRank])=99999,0,Min([TCIWeekRank]) - 1)';

please help

Gysbert_Wassenaar — Wed, 01 Aug 2018 09:28:21 GMT

Ok, that expression does not ignore selections. Add {1} in the min functions there too.

joeybird — Wed, 01 Aug 2018 09:35:52 GMT

sorry to ask, but where best to add this too the expression please?

would this be correct below please? as the load wont show the error

LET vWeekAdjust = ' =if({1}Min([TCIWeekRank])=99999,0,Min([TCIWeekRank]) - 1)';

Gysbert_Wassenaar — Wed, 01 Aug 2018 09:40:16 GMT

No, IN the min function

joeybird — Wed, 01 Aug 2018 09:51:38 GMT

Like this as follows?

LET vWeekAdjust = ' =if(Min({1}[TCIWeekRank])=99999,0,Min({1}[TCIWeekRank]) - 1)';

Gysbert_Wassenaar — Wed, 01 Aug 2018 10:49:40 GMT

Yeah, looks good.

joeybird — Wed, 01 Aug 2018 14:30:48 GMT

that has worked yes thank you for the 1st IF expression, but not another

I have the following IF in another KPI, this uses > + < in the expression

sum({1

<[WeekStartDate] = ,[WeekStart] = ,[Date] = {'>=$(=vMinWeek)'}> + <[WeekStartDate] = ,[WeekStart] = ,[OrderInProgress] = {0}>

}if([WeeksWaitedFlag] + vWeekAdjust = Weeks,CurrentWeekFlag,0))

I have in the load added {1} to the vMinWeek, with no joy, selections still affect the expression. sorry to ask more..

please help