Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filter inside trend line_m

I'm trrying to add a filter inside a trend without success. Any ideas?

I would like the trend to be showed just for 2015.Year column name is ANO_EXT

linest_m(total aggr(if(sum(ENTRADA_EXT-SAIDA_EXT),sum(ENTRADA_EXT-SAIDA_EXT)),ANO_MES_EXT),ANO_MES_EXT)*

only({1}ANO_MES_EXT)+linest_b(total aggr(if(sum(ENTRADA_EXT-SAIDA_EXT),

sum(ENTRADA_EXT-SAIDA_EXT)),ANO_MES_EXT),ANO_MES_EXT)

1 Reply
Gysbert_Wassenaar

linest_m({<ANO_EXT={2015}>}total aggr(if(sum({<ANO_EXT={2015}>}ENTRADA_EXT-SAIDA_EXT),sum({<ANO_EXT={2015}>}ENTRADA_EXT-SAIDA_EXT)),ANO_MES_EXT),ANO_MES_EXT)*

only({1<ANO_EXT={2015}>}ANO_MES_EXT)+linest_b({<ANO_EXT={2015}>} total aggr(if(sum({<ANO_EXT={2015}>}ENTRADA_EXT-SAIDA_EXT),

sum({<ANO_EXT={2015}>}ENTRADA_EXT-SAIDA_EXT)),ANO_MES_EXT),ANO_MES_EXT)


talk is cheap, supply exceeds demand