Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

filtering specific value in column

0down votefavorite

I have column which has two values Import and Export

In a bar chart I want to include only Import, How can I filter it in expression? Is it like

<type = {'Import'}> 

How can I do it in Qlik?

Tags (2)
2 Replies
MVP
MVP

Re: filtering specific value in column

Yes, assuming your expression is Sum(Measure), this should work

Sum({<Type = {'Import'}>}Measure)

amalesh_mondal
New Contributor III

Re: filtering specific value in column

Hi Swapnil,

You can create a master measure or variable by applying set analysis with above mentioned expression by you.

You can filter the data as you wish!

Go through the video link it will be clear.

Set analysis – an introduction ‒ Qlik Sense Cloud

Cheers!