Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
Would you be able to share the qvw where you might have tried this out?
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