conditional formatting

[#1]

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

[rupamjyotidas]

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.

[#3]

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

[maxgro]

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

Companies:

load * inline [

C

GE

RBS

Combined

];

Zones:

load * inline [

Z

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,

  Z

resident Zones;

[jonas_rezende]

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!

[MarcoWedel]

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

[dineshm030]

Hi,

Refer the attachment. This example helps to u.

But different data.