filtering specific value in column

[#1]

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?

[sunny_talwar]

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

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

[Anonymous]

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!