topic Re: conditional formatting in QlikView

conditional formatting

Wed, 25 Nov 2020 16:16:04 GMT

hi,

i have a three companies with different zones.

1. GE

2. RBS

3. Combined

and in GE i have different zones named as

ABC

DEF

QWE

RET

and in RBS i have

ABCS

XYZ

POI

LKJ

and in combined i have zones from those two companies.

i have written a inline table for that as:

Load * inline [

Company_code, company

1, ABC

2, DEF

3, QWE

4, RET

5, ABCS

6,,XYZ

7,POI

8,LKJ

];

IN QLIK now i have created a one listbox with three companies.

when i click on GE list box i should get only GE company names like ABC, DEF, QWE and RET

when i click on RBS i should get only ABCS, XYZ, POI, LKJ

when i click on Combined i should get all the names.

all these i should get in one list box only.

please help

Re: conditional formatting

rupamjyotidas — Wed, 23 Nov 2016 16:05:59 GMT

Can you share a sample App.

Are GE, RBS different fields or part of same field i.e. Company

What is Company Code, does it links to Company

The Inline table is a Zone table or a Company Table , as I see a Company Field.

Re: conditional formatting

Wed, 23 Nov 2016 16:34:43 GMT

hi,

i have a three companies with different zones.

1. GE

2. RBS

3. Combined

and in GE i have different zones named as

ABC

DEF

QWE

RET

and in RBS i have

ABCS

XYZ

POI

LKJ

and in combined i have zones from those two companies.

i have written a inline table for that as:

Load * inline [

Company_code, zones

1, ABC

2, DEF

3, QWE

4, RET

5, ABCS

6,,XYZ

7,POI

8,LKJ

];

IN QLIK now i have created a one listbox with three companies.

when i click on GE list box i should get only GE zones like ABC, DEF, QWE and RET

when i click on RBS i should get only ABCS, XYZ, POI, LKJ

when i click on Combined i should get all the names.

all these i should get in one list box only.

please help

Re: conditional formatting

maxgro — Wed, 23 Nov 2016 17:35:00 GMT

Add a table (Link in my script) to link zones and companies

Companies:

load * inline [

RBS

Combined

];

Zones:

load * inline [

ABC

DEF

QWE

RET

ABCS

XYZ

POI

LKJ

];

Link:

load * inline [

C, Z

GE,ABC

GE,DEF

GE,QWE

GE,RET

RBS,ABCS

RBS,XYZ

RBD,POI

RBS,LKJ

];

Concatenate (Link)

load

'Combined' as C,

resident Zones;

Re: conditional formatting

jonas_rezende — Wed, 23 Nov 2016 17:48:52 GMT

Hi, sona chiks.

See if the code below helps.

Company:

LOAD * Inline [

IdCompany, Company

1,GE

2,RBS

3,Combined

];

Company_Zone:

LOAD * Inline [

Zone, IdCompany

ABC, 1

DEF, 1

QWE, 1

RET, 1

ABCS,2

XYZ, 2

POI,2

LKJ,2

];

Outer Join ('Company_Zone')

Load

Zone,

3 AS IdCompany

Resident Company_Zone;

Hope this helps!

Re: conditional formatting

MarcoWedel — Thu, 24 Nov 2016 00:27:31 GMT

Hi,

one solution could be to use a drill down group in your listbox:

table1:

LOAD * INLINE [

zone, company

GE, ABC

GE, DEF

GE, QWE

GE, RET

RBS, ABCS

RBS, XYZ

RBS, POI

RBS, LKJ

Combined, ABC

Combined, DEF

Combined, QWE

Combined, RET

Combined, ABCS

Combined, XYZ

Combined, POI

Combined, LKJ

];

hope this helps

regards

Marco

Re: conditional formatting

dineshm030 — Thu, 24 Nov 2016 05:21:28 GMT

Hi,

Refer the attachment. This example helps to u.

But different data.