I want to make a bar chart that displays the situation at a few key customers of interrest (hard coded) regardless of which locations that are chosen in the list boxes (this for attracting user's focus to what is defined as organization focus area).
I'm new to Qlikview, but I think I have to create a calculated dimension. P.t. it has following syntax:
if(Customer = 'AAAA' or Customer = 'BBBB' or Customer = 'CCCC', Customer, Null()).
When I use this and suppress nulls, I almost get what I want. But if I choose a customer in a list box, it filters on that as well. How can I avoid that for this spesific chart? Can I utilize set analysis for this context to make sure it filters from all customers {1}?
Thanks! When I combine the suggestions, the expression sum( {<Customer= {'A','B'} >} Sales ), and no calculated dimension, seems to give me my preferred result. Ref solution chart in attached document.
It reflects the date/month selections in the listbox, but displays always customers A and B, and not C, in the chart regardless of selections in Customer list box. Sorry for beeing inaccurate in my descriptions.
