Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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])))))