Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

vipin_mishra479
Contributor II

selection issue

hi i have a 3 field

order, material , and level

326001 is my order and 1224 is my material for respect to that i have two level 04.02.01 and 04.02.02 which is text formate

eg.  order          material      level

       326001      1224           04.02.01 , 04.02.02

       326112       3251          06.01.00

       326521       2215          05.02.03

and my question is that

when i select   this 326001 order and   this material 1224  then how to i get only 04.02.02  level

1 Reply
deepakk
Valued Contributor III

Re: selection issue

Hi vipin,

Create another field as below

subfield(level,',',1) as level1,

subfield(level,',',2) as level2

So when you select 326001 and 1224 u will get 04.02.02 in level1

Deepak

Community Browser