Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

sachinnataraj
New Contributor II

adding multiple filter

Hello,

Can you please help me in adding multiple filter in #kpi

At present i have used this formula

Count({$<Position={"changed"}>}distinct [Customer Name])

now i need to add another filter (year = 2016) to this.

Thank you in advance,

Sachin

3 Replies
luismadriz
Valued Contributor

Re: adding multiple filter

Hi,

please try this if year is numeric:

Count({$<Position={"changed"},year={2016}>}distinct [Customer Name])


I hope this helps,


Cheers,


Luis

sachinnataraj
New Contributor II

Re: adding multiple filter

Hello Luis,

This works, Thanks a lot.

Cheers,

Sachin

luismadriz
Valued Contributor

Re: adding multiple filter

Good,

When you get a chance please close the thread by marking helpful/correct replies,

Cheers,

Luis

Community Browser