Qlik Sense Filter Within an Expression

Anonymous — Wed, 03 Feb 2016 08:37:12 GMT

Hello Everyone!

So I have this expression, and I was wondering if there is a way to use a filter within that expression. For example:

this is my expression:

Count({$< StatusesId = {1}, ItemsCon -={16}>} distinct RequestId)

So what I would like to do is to provide a user with a filter so that the user can choose "ItemCon"; I would like to enable the user to either choose nothing: so the expression will be like:

Count({$< StatusesId = {1}, >} distinct RequestId)

or allow the user to specify a value for ItemCon to be excluded:

Count({$< StatusesId = {1}, ItemsCon -={16}>} distinct RequestId)

or allow the user to specify a value for ItemCon to be included:

Count({$< StatusesId = {1}, ItemsCon ={16}>} distinct RequestId)

Your help is appreciated!

Thanks!

Re: Qlik Sense Filter Within an Expression

sunny_talwar — Wed, 03 Feb 2016 17:38:51 GMT

Try this may be:

for excluding selection

Count({$< StatusesId = {1}, ItemsCon = e(ItemsCon)>} Distinct RequestId)

Wait, how will the expression should know when to include and when to exclude? Are you be going to use two states to do this?

topic Re: Qlik Sense Filter Within an Expression in App Development

Qlik Sense Filter Within an Expression

Re: Qlik Sense Filter Within an Expression