Discussion Board for collaboration related to QlikView App Development.
I have city as dimension and sales as measure(=sum(sales))
In city we have
Boston,LA,Seattle and so on.
I want a bar chart that will show us the sales per city, however by default Boston should be always on the top of the bar chart.(even if the sales is less)
Then all other city would appear in descending order.
Is it do able ?
May be sort order as expression
Dual(Match(city, 'Boston'), city)
Can you share QVW file, meantime you can try this too with descending order
You can try;
INLINE [ City, Sales Boston, 10000 LA, 26000 Seattle, 200 Washington, 500000 MA, 3000 ];
Dimension - City
Thank you so much for your solution.
I am wondering why =maxsales (in text box) giving me error in expression. so does the the expression in sort tab.