Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

smusayev
New Contributor

Filter out data in the expression in Qlik Sense

Hello everyone,

I am a new to Qlik sense and I am hoping you can help with resolving issues I am having.


I currently have a column/field in my table that measures compliance by either having 'Yes' or 'No'.

The way my graph/chart is currently set up, is that it has

     Dimension:  Month, Count(Compliance)

     Measure:  Count(Compliance)

     The product shows 2 bars, 1 that is 'Yes' and the other that is 'No' for each month in the data.

     I am trying to create a graph/chart that will only show 'Yes' but not 'No' for my compliance column,

        meaning only show 1 bar which will only represent 'Yes'.

Can you please help or guide me to the answer.

I have another question similar to the above but will post it separately.

Thank you

1 Solution

Accepted Solutions
galax_allu
Valued Contributor

Re: Filter out data in the expression in Qlik Sense

Hi

Try this .. in Mesaure

count({1<compliance={'Yes')>} Complaince)

2 Replies
MVP
MVP

Re: Filter out data in the expression in Qlik Sense

You can try this:

Dimension:

Month

Compliance

Expression:

Count({<Compliance = {'Yes'}>} Compliance)

galax_allu
Valued Contributor

Re: Filter out data in the expression in Qlik Sense

Hi

Try this .. in Mesaure

count({1<compliance={'Yes')>} Complaince)