Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Restrict Data in Chart/ Straight table

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.

 

COLOMBIALATAMA
VENEZUELALATAMB
PANAMALATAMA
GUATEMALALATAMA
PERULATAMA
TRINIDAD AND TOBAGOLATAMB
EL SALVADORLATAMB
BARBADOSLATAMB
BOLIVIALATAMC
URUGUAYLATAMD
DOMINICAN REPUBLICLATAME
JAMAICALATAME
ARUBALATAME
ANGUILLALATAMA
SAINT KITTS AND NEVISLATAMA

Thanks in advance.

13 Replies
Highlighted

Use set analysis within the expression:

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

Highlighted
MVP
MVP

Use below calculated dimension in straight table

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

Tick Suppress When Value is Null

Highlighted
MVP
MVP

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)

Highlighted
Partner
Partner

Please see attached file

Highlighted
Master II
Master II

Hi,

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

Highlighted
Partner
Partner

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

Highlighted
Creator III
Creator III

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

Highlighted
Partner
Partner

Here you go, as per my example

Highlighted

On similar lines:

Output:

Capture.PNG

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

Expression: None

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

Capture.PNG

I hope this helps

Best,

Sunny