Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
venanciop
Contributor II
Contributor II

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