Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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
Partner - Champion III
Partner - Champion III

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