Restrict Data in Chart/ Straight table

[ashishpalkar]

Hi There

I have requirement as below, in the following table i just want to see data for A,B & C in the straight table / Chart table.

COLOMBIA	LATAM	A
VENEZUELA	LATAM	B
PANAMA	LATAM	A
GUATEMALA	LATAM	A
PERU	LATAM	A
TRINIDAD AND TOBAGO	LATAM	B
EL SALVADOR	LATAM	B
BARBADOS	LATAM	B
BOLIVIA	LATAM	C
URUGUAY	LATAM	D
DOMINICAN REPUBLIC	LATAM	E
JAMAICA	LATAM	E
ARUBA	LATAM	E
ANGUILLA	LATAM	A
SAINT KITTS AND NEVIS	LATAM	A

Thanks in advance.

[qlikviewwizard]

Hi ashishpalkar

Did you able to manage to solve your issue? Thank you.

[mohammadkhatimi]

PFA.

Complete description on how to use set analysis...

Hope this will helps you to use set analysis...

Regards,

Mohammad

[csmqlik01]

Hi Sunny,

I have also a straight table with fields 'Registration date' - ' ID' - ...

But within ID I have  EHS2010-0001 ...  but also MOC20xx-xxxx  and now I want to filter on EHS with your suggestion

=If(Match(Field3, 'A', 'B', 'C'), Field3)  =>  if(Match(ID, 'EHS'), ID)  but then I have no records 

Any suggestion 

Best regards,

Eddy

[csmqlik01]

Hi Everyone,

I've put the filter in the calculation expression and now it works

Br

Eddy