Not sure if I understand your question (it's easier to understand if you post your current script snippet and maybe some sample lines of records), but maybe you can create a link table like this
Recno() as RecID
Crosstable (FieldName, FieldValue)
LOAD RecID, FieldA, FieldB
Then use a list box of field FieldValue to select in all values of FieldA and FieldB.
Hi stefan ,
Thanks for your reply. Here i have addedd the code which I have written in my Qlik to create two fields from a single field. Hope it helps you more.
IF(Match(MTU_METADATAKEYFK, 'Indication'),MTU_METADATAVALUENAME ) AS [Sub Category],
IF(Match(MTU_METADATAKEYFK, 'Product'),MTU_METADATAVALUENAME ) AS Category;
Could you please take a look and let me know?
Goto>Settings>Document Properties>Triggers>FieldEvent Trigger>Onselect Action>Add Select Excluded>YourFieldName.
This will exclude all the values selected in youefield name.
I cannot think of otherwise, however if there is a same value in both filters then it will match.
You can try that or you'll have to write a macro and add it to trigger. Let the experts speak on this, my knowledge is not at expertise level.
Not sure but it seems you want to make selection but want to ignore the association effect similar to what we do with qlikview alternate state. But our objective in those situation is to make comparison in front end. I believe its not available yet in QlikSense without extension. What if you create two sets of fields in script by duplicating the code and changing field names like subcategory1, category1. Just throwing idea in case it can relate to your need.