Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

ignore selections using if Qlik Sense

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

8 Replies
Gysbert_Wassenaar

What is the expression in vWeekAdjust?


talk is cheap, supply exceeds demand
joeybird
Creator III
Creator III
Author

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

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


talk is cheap, supply exceeds demand
joeybird
Creator III
Creator III
Author

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


talk is cheap, supply exceeds demand
joeybird
Creator III
Creator III
Author

HI

Like this as follows?

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

Gysbert_Wassenaar

Yeah, looks good.


talk is cheap, supply exceeds demand
joeybird
Creator III
Creator III
Author

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