Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ts3st1000
New Contributor

Filter on a measure

Hi, I am showing a table on a measure, and I was wondering if there is an easy way to add a filter on it please. On the table below, I have country defined as a measure ( it does not work as a dimension), but i would like to filter on it.

 

countrysales
Japan10
Vietnam11
Malaysia12
China13

Thanks for the help.

2 Replies
felipedl
Valued Contributor III

Re: Filter on a measure

Hi,

Do you mean you want to filter your expression for some specific contry?

If so, you can use set analysis and as an example, if you want the sales for Japan only, you could do:

sum({<country={"Japan"}>}sales)

Felipe.

omarbensalem
Esteemed Contributor

Re: Filter on a measure

or u can create a new filter/dimension in ur presentation as a master dimension, as follow:

if(country='Japan',country,null())

name it as u want; and drag it a new filter