topic Re: Multiple nested commands in QlikView

Multiple nested commands

jgraunke77 — Thu, 08 Feb 2018 11:03:52 GMT

Hi,

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

ID	Example	Example1	Example2	Example3	Example5	Example6	Example7	Example8
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...

Re: Multiple nested commands

sunny_talwar — Thu, 08 Feb 2018 17:11:02 GMT

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

Re: Multiple nested commands

MarcoWedel — Thu, 08 Feb 2018 21:19:02 GMT

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