Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
jgraunke77
New Contributor II

Multiple nested commands

Hi,

I have a csv-table that looks roughly like this:

IDExampleExample1Example2Example3Example4Example5Example6Example7Example8Example9
1{'Example1':-5,'Example3':10}-510
2{'Example2':-7,'Example5':15}-715
3{Example1':10,'Example3':-2,'Example6':-11}10-211
4{'Example1':-3,'Example2':-4,'Example3':15}-3-415
5{'Example7':-28}-28
6{'Example3':-1,'Example8':-2}-1-2

I've tried:
SubField((SubField((KeepChar(Example, 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789+-:,')), ',')), ':', 1) as ExampleList

to get following:

ExampleList
Example1
Example2
Example3
Example4
Example5
...

Then when I click on "Example2" in that list, I want that all the rows are selected, that contain "Example2".

But it's selecting rows, that aren't containing the selected...

2 Replies

Re: Multiple nested commands

Would you be able to share the qvw where you might have tried this out?

Re: Multiple nested commands

Hi,

maybe one solution could be:

QlikCommunity_Thread_290724_Pic1.JPG

QlikCommunity_Thread_290724_Pic2.JPG

table1:

LOAD ID,

    Example

FROM [https://community.qlik.com/thread/290724] (html, codepage is 1252, embedded labels, table is @1);

table2:

LOAD ID,

    TextBetween(SubField(SubStr1,':',1),Chr(39),Chr(39)) as ExampleList,

    SubField(SubStr1,':',2) as Value;

LOAD ID,  

    SubField(TextBetween(Example,'{','}'),',') as SubStr1

Resident table1;

table3:

Generic

LOAD * Resident table2;

hope this helps

regards

Marco

Community Browser