topic Restrict Data in Chart/ Straight table in QlikView

Restrict Data in Chart/ Straight table

ashishpalkar — Thu, 13 Aug 2015 14:09:44 GMT

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.

Re: Restrict Data in Chart/ Straight table

sunny_talwar — Thu, 13 Aug 2015 14:11:57 GMT

Use set analysis within the expression:

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

Re: Restrict Data in Chart/ Straight table

MK_QSL — Thu, 13 Aug 2015 14:12:17 GMT

Use below calculated dimension in straight table

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

Tick Suppress When Value is Null

Re: Restrict Data in Chart/ Straight table

swuehl — Thu, 13 Aug 2015 14:12:35 GMT

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)

Re: Restrict Data in Chart/ Straight table

maximiliano_vel — Thu, 13 Aug 2015 14:20:46 GMT

Please see attached file

Re: Restrict Data in Chart/ Straight table

qlikviewwizard — Thu, 13 Aug 2015 15:02:53 GMT

Hi,

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

Re: Restrict Data in Chart/ Straight table

awhitfield — Thu, 13 Aug 2015 15:16:06 GMT

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

Re: Restrict Data in Chart/ Straight table

ashishpalkar — Thu, 13 Aug 2015 15:31:16 GMT

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

Re: Restrict Data in Chart/ Straight table

awhitfield — Thu, 13 Aug 2015 15:46:24 GMT

Here you go, as per my example

Re: Restrict Data in Chart/ Straight table

sunny_talwar — Thu, 13 Aug 2015 15:51:45 GMT

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

Re: Restrict Data in Chart/ Straight table

qlikviewwizard — Fri, 14 Aug 2015 03:07:32 GMT

Hi ashishpalkar

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

Re: Restrict Data in Chart/ Straight table

mohammadkhatimi — Fri, 14 Aug 2015 04:27:32 GMT

PFA.

Complete description on how to use set analysis...

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

Regards,

Mohammad

Re: Restrict Data in Chart/ Straight table

csmqlik01 — Tue, 07 Jan 2020 15:29:00 GMT

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

Re: Restrict Data in Chart/ Straight table

csmqlik01 — Wed, 08 Jan 2020 08:13:49 GMT

Hi Everyone,

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

Eddy