Group data on a bar chart to create an 'Others' category
I'm a newbie on the Qlikview World, so I really need your help
I've been looking on the forums and I can't found an exact answer to my problem.
I have a bar chart and a dimension called "Values". When I selected items from "Values", they appears on the chart. My problem is that besides the selected data I need to add a new one called 'Others', that contains the summatory of the non selected data.
Got it working. ValueList() is very strict about what it receives and Concat() doesn't directly work. Instead I have created a variable vValueList that builds up a ValueList() expression. Then, in your dimension just used $(vValueList) to evaluate the expression. This is a common approach for certain dynamic set anlaysis expressions too. vValueListis: