topic Re: count in QlikView

count

Fri, 26 Jun 2015 08:35:10 GMT

Hi All,

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.

Regards

John

Re: count

jsingh71 — Fri, 26 Jun 2015 08:59:04 GMT

Something like this, see attachment

I am using personal edition..if you need any changes then plz attach screenshot.

Re: count

jagan — Fri, 26 Jun 2015 09:09:20 GMT

Hi,

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))

Regards,

Jagan.

Re: count

Fri, 26 Jun 2015 09:24:42 GMT

PFA

Re: count

Fri, 26 Jun 2015 10:02:14 GMT

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.

Regards

John

Re: count

jagan — Fri, 26 Jun 2015 10:04:38 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: count

Fri, 26 Jun 2015 10:18:37 GMT

Hi Jagan, thanks it works. I have one doubt here if my branch is duplicated several time at that time also I want only distinct records how can I get it.

Regards

John

Re: count

jagan — Fri, 26 Jun 2015 10:21:37 GMT

Hi,

Your number range is

<=450

>600

>400 <=650

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.

Example:

<=400

>400 <=650

>650

Now you won't get duplicates.

Regards,

Jagan.

Re: count

Fri, 26 Jun 2015 13:12:30 GMT

Hi Jagan,

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.

Regards

John