ignore selections using if Qlik Sense

[joeybird]

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]

What is the expression in vWeekAdjust?

[joeybird]

Hi

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 · Accepted solution]

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

[joeybird]

Hi

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]

No, IN the min function

[joeybird]

HI

Like this as follows?

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

[Gysbert_Wassenaar]

Yeah, looks good.

[joeybird]

Hi

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