Discussion Board for collaboration related to QlikView App Development.
Hi, I have this situation....
A cvs column with information like this.....
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
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:
Is it possible? how ?
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 ];
View solution in original post