topic Re: Stack Bar Graph_Urgent in QlikView

Stack Bar Graph_Urgent

Fri, 25 Apr 2014 07:33:31 GMT

Hi All,

I need your help to show the percentage of a sales at a specific time vs full time in a single stacked bar.

I put two expressions for that, which is not reflecting the correct picture as the portion is showing the wrong picture.

Re: Stack Bar Graph_Urgent

rajat2392 — Fri, 25 Apr 2014 07:49:07 GMT

your 2nd expression is for total no of sales man..and what you need is the sales man those having less than 500 sales, so change the expression..I have attached the app, you can do this in 2 ways....

check graph1 and graph 2

Re: Stack Bar Graph_Urgent

Fri, 25 Apr 2014 07:49:52 GMT

Is it better?

Re: Stack Bar Graph_Urgent

MK_QSL — Fri, 25 Apr 2014 08:15:00 GMT

Create a Bar Chart

Dimension

NO DIMENSION

Expression

1) COUNT(DISTINCT Salesman)-COUNT({<Salesman = {"=SUM(Sales)<500"}>}DISTINCT Salesman)

2) =COUNT(DISTINCT Salesman)-COUNT({<Salesman = {"=SUM(Sales)>=500"}>}DISTINCT Salesman)

Style Tab

Orientation = Horizontal

SubType = Stacked

Hope this helps...

Re: Stack Bar Graph_Urgent

Fri, 25 Apr 2014 08:36:57 GMT

Thanks All for the help.