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.

[sunny_talwar]

Use set analysis within the expression:

{<Field3 = {'A', 'B', 'C'}>}

[MK_QSL]

Use below calculated dimension in straight table

IF(Match(FieldName,'A','B','C'),FieldName)

Tick Suppress When Value is Null

[swuehl]

Either use a calculated dimension, something like

=If (Match(Field,'A','B','C'), Field)

or set analysis in all your aggregations in the expressions, something like

=Sum({<Field = {'A','B','C'}>} Value)

[maximiliano_vel]

Please see attached file

[qlikviewwizard]

Hi,

Please check the attached file. Hope this will help you.

[awhitfield]

Hi Ashish,

an easy way:

Data:
Load * Inline
[Field1, Field2, Field3
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
];

Hide the column with the expression in it!

HTH - ANDY

[ashishpalkar]

Thanks this was really helpful, can somebody share file where Set Analysis is used?

[awhitfield]

Here you go, as per my example

[sunny_talwar]

On similar lines:

Output:

Dimensions:  Field1, Field2 and =If(Match(Field3, 'A', 'B', 'C'), Field3)

Expression: None

On the presentation tab: Uncheck 'Suppress When Null' option

I hope this helps

Best,

Sunny