I'm not sure how to use this function. The examples I've seen seem to focus on dates and such and not really fields with good examples. I'm using qlik sense and have data coming in. I want to take the dimension I'm using and sort based on the text in a bar chart but for some reason the sort isn't working and someone suggested using the dual function.
Here is the data I'm loading:
Pick(WildMatch(GroupItem, '*Arcadia*','*Airman*'),'Other', GroupItem) as NewNonCustomer;
SubField(NonCustomer, ',') as GroupItem;
The data loads and I pull in the dimension to the chart, GroupItem and the measure, GroupItem(Count). When the chart displays, I get the correct data but the data does not sort alphabetically even though qlik sense says it is. The data displays as follows:
Someone suggested using the dual function but that doesn't seem to work.