Discussion Board for collaboration on QlikView Layout & Visualizations.
Hi everyone !
I've a little question about a function that could allow me to "gather" multiple data types into one
I've a database with a lot of "subtypes", like this :
Type1-Subtype1 | x35
Type1-Subtype2 | x60
Type1-Subtype3 | x11
I'm displaying all this list in a Filter Pane but I would like to gather those datas just like this :
Type1 | x106 (for example)
Is there any function to do that ?
Thanks in advance !
Gather this information where? Not sure I understand the purpose?
SubField(field, '-', 1) & ' | ' & SubField(field, '|', -1) as newfield
Hi guys !
It looks like the example of maxgro but I would like to add all datas together ( Type1 = 106 for example).
BTW I want to "gather" those information in the display in the Filter Pane from the GUI.But of course I can do something during the load of the datas.
And ... sorry for my English x)