Discussion Board for collaboration related to QlikView App Development.
Can any one help on the below scenario. I have Manager, Branch, Sales fields, now I would like to show a stacked bar chart with
Manager as dimension and count(branch) as expression as stacked bar chart. for that I have 3 colors when for each bar segment,
if sum(sales)<450,RGB(0,68,0)), if(sum(sales)>450,RGB(0,168,0)),if(sum(sales) >600,RGB(10,168,30)), and in these segments I would like to show the count of braces. which are meeting the above conditions.
Please find attached file for solution.
Used below expressions
=Sum(aggr(if(sum(sales)<=450, 1), Manager, Branch))
=Sum(Aggr(if(sum(sales)>600, 1),Manager, Branch))
=Sum(Aggr(if(sum(sales)>400 and sum(sales)<=650, 1),Manager, Branch))
Hi Jagan Thanks,
I didn't find the attachment. and I have used the expressions but it is displaying like group but I want it in stacked bar, how can I achieve it.
Your number range is
So, the second range and third range you will get duplicate count, so fix the ranges so that it won't satisfy for two conditions.
Now you won't get duplicates.
Now I want show those branch numbers whenever a click has happened on any segment of the bar , how can I show those branches, could you please help me on that.