Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

it-golestan
New Contributor III

set condition to show specific data on bar chart

Hello every one

i wanna show only values that  <=0 in a bellow expression on bar chart

Avg(A-B)

i would much appreciate if any body here could helpme

4 Replies

Re: set condition to show specific data on bar chart

if(avg(A-B)<=0,avg(A-B))


talk is cheap, supply exceeds demand
it-golestan
New Contributor III

Re: set condition to show specific data on bar chart

thank you so much Gysbert it solved

i have another question too

my instruction work correctly for each row but when yo select some values in chart, it doesn't work correctly.

if(IsNull(RecieveMonth) ,Avg('42280'- SendMonth ), Avg(RecieveMonth-SendMonth))

thanks

Re: set condition to show specific data on bar chart

Try avg({1}rangesum(alt(ReceiveMonth,42280),-SendMonth))


talk is cheap, supply exceeds demand
it-golestan
New Contributor III

Re: set condition to show specific data on bar chart

So many thanks Gysbert

Community Browser