Multiple nested commands

[jgraunke77]

Hi,

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

ID	Example	Example1	Example2	Example3	Example4	Example5	Example6	Example7	Example8	Example9
1	{'Example1':-5,'Example3':10}	-5		10
2	{'Example2':-7,'Example5':15}		-7			15
3	{Example1':10,'Example3':-2,'Example6':-11}	10		-2			11
4	{'Example1':-3,'Example2':-4,'Example3':15}	-3	-4	15
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...

[sunny_talwar]

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

[MarcoWedel]

Hi,

maybe one solution could be:

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