Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
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
sunny_talwar

Use set analysis within the expression:

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

MK_QSL
MVP
MVP

Use below calculated dimension in straight table

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

Tick Suppress When Value is Null

swuehl
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)

maximiliano_vel
Partner - Creator III
Partner - Creator III

Please see attached file

qlikviewwizard
Master II
Master II

Hi,

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

awhitfield
Partner - Champion
Partner - Champion

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
Creator III
Creator III
Author

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

awhitfield
Partner - Champion
Partner - Champion

Here you go, as per my example

sunny_talwar

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