Help required in data hierarchy

Fri, 28 Dec 2012 16:14:13 GMT

I have only 2 columns.i need data hierarchy. Pl Help

Short_Desc	Material_Name
Aerobid	(DISC)AEROBID-M PLACEBO DISPLAY EACH
Aerobid	AEROBID-M SAMPLE(1 CAN X 7GM) 7GM DISC
Aerobid	DISC AERO BRONCTREE MODEL EACH
Aerobid	DISC AEROBID-M INHALER SYSTEM 7GM
Aerobid	DISC AEROBID-M PA SAMPLE (1 CAN x 3.5GM)
Aerobid	DISC AEROBID-M SAMPLE(1 CAN X 3.5 GM)
Aerobid	DISC AEROBID-PA SAMPLE (1 CAN x 3.5GM)
Aerobid	DISC AEROBID INHALER SYSTEM 7GM
Aerobid	DISC AEROBID SAMPLE (1 CAN X 3.5 GM)
Aerobid	DISC AEROBID SAMPLE(1 CAN X 7GM) 7 GM
Aerobid	DISC AEROCH. DEMO CTR W/MOUTHPCE BX 20
Aerobid	DO NOT USE * AEROBID-M PLACEBO -> 2489
Aerobid	DO NOT USE * AEROBID PLACEBO CAN&HOLDER
Benicar	DISC Benicar 20/12.5mgHCT Sampl 7-bottle
Benicar	DISC Benicar 20mg Sample (10307) 1X7
Benicar	DISC Benicar 20mg Sample 7ct bottle each
Benicar	DISC Benicar 20mg/12.5mg HCT 30ct EEP ea
Benicar	DISC Benicar 40/12.5mgHCT Smpl 7-btl eac
Benicar	DISC Benicar 40/25mgHCT Sample 7ct bottl
Benicar	DISC Benicar 40mg Sample (#10407) 1X 7
Benicar	DISC Benicar 40mg Sample 7ct bottle each
Benicar	DISC Benicar 40mg/12.5mg HCT 30ct EEP ea
Benicar	DISC Benicar JNC7 Goal Program
Celexa	CELEXA 1 OZ
Celexa	CELEXA 20MG 90
Celexa	CELEXA 20MG 500
Celexa	CELEXA 20MG 1000
Celexa	CELEXA 20MG 5000
Celexa	CELEXA 40MG 90
Celexa	CELEXA 40MG 500
Celexa	CELEXA 40MG 1000
Celexa	CELEXA 40MG 5000
Celexa	CELEXA BULK 10MG TABLETS TRADE
Celexa	CELEXA BULK 10MG TABLETS Validation
Celexa	CELEXA BULK 20MG TABLETS TRADE
Celexa	CELEXA BULK 40MG TABLETS TRADE
Celexa	CELEXA TABLETS 10MG 100
Celexa	CELEXA TABLETS 20MG 100
Celexa	CELEXA TABLETS 20MG(CHALLENGE) 30 DISC
Celexa	CELEXA TABLETS 40MG 100
Celexa	CITALOPRAM HBR
Celexa	DISC CELEXA-PA 20MG Sample 1X7 1 each
Celexa	DISC CELEXA-PA 20mg STRTR KIT 1x14 1cd
Celexa	DISC Celexa-PA Tablets 40mg 100
Celexa	DISC CELEXA 4 OZ
Celexa	DISC CELEXA Liquid 8 OZ
Celexa	DISC CELEXA 20MG 30
Celexa	DISC CELEXA 20MG H.U.D. 10X10
Celexa	DISC CELEXA 20MG SAMPL(1X7 W/O GRAV)1CRD
Celexa	DISC CELEXA 20MG SAMPLE (1x7 TAB) 1 CARD
Celexa	DISC CELEXA 20MG STRTR KIT(1x14TAB)1CARD
Celexa	DISC CELEXA 20MG TABLET SAMPLES BULK

Re: Help required in data hierarchy

montero91 — Fri, 28 Dec 2012 17:22:06 GMT

Hi Kirti,

Create a new field Short_Desc & '/' & Material_Name as TreeView.
With the new field inserts a list, in the General tab enable show as TreeView whit Separator '/'.

I hope you serve or you can give an example of what you seek.

Re: Help required in data hierarchy

Fri, 28 Dec 2012 18:03:05 GMT

I have tried that as well but by doing this i am not able to select Short _Desc.. I have to select respective material_Name only.

What i am looking for is when i click on Short_Desc, all correponding Material_Name should get selected.

Re: Help required in data hierarchy

Gysbert_Wassenaar — Fri, 28 Dec 2012 18:18:18 GMT

See attached qvw.

Re: Help required in data hierarchy

Fri, 28 Dec 2012 19:45:26 GMT

Awesome..!! Thnx..

topic Re: Help required in data hierarchy in QlikView

Help required in data hierarchy

Re: Help required in data hierarchy

Re: Help required in data hierarchy

Re: Help required in data hierarchy

Re: Help required in data hierarchy