Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude object form selection / filter

I want to exclude an object (line chart) from a selection (i.e. the year). If the year is 2013 or earlier then I use static data, if the year is 2013 or later the variable is calculated by cost divided by number of FTEs. Regardless of the year selected, I want to see all the years in the line chart.

if(year<2013,

(ALT( sum({1}{ <Year= >}[TCO per fte]), 0) ),

(ALT( sum({ <Jaar = >} Total cost part A, 0) + (ALT( sum({ <Jaar = >} (Total costs part B)))))

/

ALT( sum({ <Year= >} ([Total fte]))))

2 Replies
Not applicable
Author

Just add the second set of criteria using another if() statement:

if(year<2013,

(ALT( sum({1}{ <Year= >}[TCO per fte]), 0) ),

     if(year>=2013

           (ALT( sum({1}{ <Jaar = >} Total cost part A, 0) + (ALT( sum({ <Jaar = >} (Total costs part B)))))

           /

      ALT( sum({1}{ <Year= >} ([Total fte]))))

)

Not applicable
Author

unfortunately; this isn't working. If I make a selection on "year" this still has an effect on the chartline. Only selected years are shown, and I wanted to see all years.

       if(Year<2013,

(ALT( sum({1}{ <Year= >}[TCO per fte]), 0) ),

if(Year>=2013,

(ALT( sum({1}{ <Year= >} Total cost part A), 0) + (ALT( sum({1}{ <Year= >} (Total cost part B)))))

/

ALT( sum({1}{ <Year= >} ([Total fte])))))