topic Exclude object form selection / filter in QlikView

Exclude object form selection / filter

Mon, 18 Aug 2014 13:41:04 GMT

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]))))

Re: Exclude object form selection / filter

Mon, 18 Aug 2014 14:23:09 GMT

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]))))

)

Re: Exclude object form selection / filter

Mon, 18 Aug 2014 14:52:49 GMT

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])))))