Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rafael5958
Creator
Creator

creating list (table) with part of a string

Hi, I have this situation....

A cvs column with information like this.....

M:\2016\aaaaa\vvvv\gggg\jjjjjj

M:\2016\aaaaa\vvvv\gggg\jjjjjj

M:\2015\bbb\vvvv\hhhh

M:\2015\bbb\vvvv\hhhh

F:\2016\HJFHSJK\DFDF\KJKJDKS

F:\2016\HJFHSJK\DFDF\KJKJDKS

F:\2016\HJFHSJK\DFDF\KJKJDKS

F:\2016\HJFHSJK\DFDF\KJKJDKS

What I want to do is to create 2 lists (or table if its easier to implement), one with the string till the 3rd "\" and one with the string between the 2nd and 3rd "\", something like

list one:

M:\2016\aaaaa\

M:\2015\bbb\

F:\2016\HJFHSJK\

list two:

aaaaa

bbb

HJFHSJK

And in the table with the column populated from the cvs, i want to filter all searchs with the string in the list one. For example, if I click in "M:\2016\aaaaa\" in list one, it will filter:

M:\2016\aaaaa\vvvv\gggg\jjjjjj

M:\2016\aaaaa\vvvv\gggg\jjjjjj.

Is it possible? how ?

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi Rafael,

maybe this

LOAD TextField,Left(TextField,Index(TextField,'\',3)) as FieldA,
SubField(TextField,'\',3) as FieldB Inline [
TextField
M:\2016\aaaaa\vvvv\gggg\jjjjjj
M:\2016\aaaaa\vvvv\gggg\jjjjjj
M:\2015\bbb\vvvv\hhhh
M:\2015\bbb\vvvv\hhhh
F:\2016\HJFHSJK\DFDF\KJKJDKS
F:\2016\HJFHSJK\DFDF\KJKJDKS
F:\2016\HJFHSJK\DFDF\KJKJDKS
F:\2016\HJFHSJK\DFDF\KJKJDKS
]
;

Regards,

Antonio

View solution in original post

1 Reply
antoniotiman
Master III
Master III

Hi Rafael,

maybe this

LOAD TextField,Left(TextField,Index(TextField,'\',3)) as FieldA,
SubField(TextField,'\',3) as FieldB Inline [
TextField
M:\2016\aaaaa\vvvv\gggg\jjjjjj
M:\2016\aaaaa\vvvv\gggg\jjjjjj
M:\2015\bbb\vvvv\hhhh
M:\2015\bbb\vvvv\hhhh
F:\2016\HJFHSJK\DFDF\KJKJDKS
F:\2016\HJFHSJK\DFDF\KJKJDKS
F:\2016\HJFHSJK\DFDF\KJKJDKS
F:\2016\HJFHSJK\DFDF\KJKJDKS
]
;

Regards,

Antonio

View solution in original post