Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


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.

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
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


Community Browser