Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

venanciop
New 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)

Tags (1)
1 Reply

Re: Filter inside trend line_m

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
Community Browser