Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

how to dynamicaly set filters with a text ?

Hello !

I'm building a simple page with one table and one graph. In this table is one dimension (costpool) and 3 measures

- AmountA : Sum({$<year={$(vCurYear)}>} amount)

- AmountB : Sum({$<year={$(vCurYear-1)}>} amount)

- Deltavalue:  Sum({$<year={$(vCurYear-1)}>} amount) -Sum({$<year={$(vCurYear)}>} amount)

the graph is a combo graph with the same information.

Pretty simple as I said.

I want to be able to filter the costpool by showing only those where the DeltaValue is above a value set by a variable vLevel.

The dimension Limit does not work because 1) it works only with the 1st measure. 2) it does not modify the filters (in other words that will not impact the graph)

Is this a way to do that ?

thank you in advance

Fred

1 Reply

Re: how to dynamicaly set filters with a text ?

May be this:

Deltavalue

=If(Sum({$<year={$(vCurYear-1)}>} amount) -Sum({$<year={$(vCurYear)}>} amount) > vLevel, Sum({$<year={$(vCurYear-1)}>} amount) -Sum({$<year={$(vCurYear)}>} amount))

AmountA

=If(Sum({$<year={$(vCurYear-1)}>} amount) -Sum({$<year={$(vCurYear)}>} amount) > vLevel, Sum({$<year={$(vCurYear)}>} amount))

AmountB

=If(Sum({$<year={$(vCurYear-1)}>} amount) -Sum({$<year={$(vCurYear)}>} amount) > vLevel, Sum({$<year={$(vCurYear-1)}>} amount))

Community Browser