topic Re: stack bar chart in QlikView

stack bar chart

xarapre7 — Wed, 11 Nov 2015 18:34:50 GMT

Hi!

I have the following for my dimension and expressions:

Dimension:

YearMonth

Expressions:

Project Count=COUNT({<KO_DAY_KEY={'>0'}>} distinct [Project ID])

CycleTime=Avg(aggr(Avg(FIRST_CYCLE_TIME),[Project ID]))

I would like the Project Count which is in Bar chart to turn into a stack bar chart by different Statuses ('Completed', 'In Progress', 'Booked', etc). What's the correct expression for the status?

Example: Project Count total for Sept 2015 = 7; Wherein 3 = Booked, 3 = Completed and 1= Pending

Looking forward for your kind help.

Thanks.

Re: stack bar chart

Wed, 11 Nov 2015 18:52:13 GMT

question - what dimension contains the project status values?

Basically you will need to have 3 expressions - in your current expression add additional set analysis to include the status field and value (you will have 3). On the style tab, set to stacked

Re: stack bar chart

xarapre7 — Wed, 11 Nov 2015 19:05:06 GMT

The Project status values is in the Dimension 'Status'. But I used dimension Go-Live Mth-Yr which is in cyclic group. This is how i want it to look like except for those bars need to be stacked bars by status.

Re: stack bar chart

Wed, 11 Nov 2015 19:13:23 GMT

sounds like your dimension needs to stay how you have it and then you will have 3 expressions - all 3 would be duplicates of the expression you have but would included additional set analysis check for Status

example

COUNT({<KO_DAY_KEY={'>0'} , Status = {Completed}>} distinct [Project ID])

COUNT({<KO_DAY_KEY={'>0'} , Status = {Booked}>} distinct [Project ID])

COUNT({<KO_DAY_KEY={'>0'} , Status = {Pending}>} distinct [Project ID])

Re: stack bar chart

xarapre7 — Wed, 11 Nov 2015 19:31:36 GMT

It worked! Thank you Adam! I really appreciate your kind help.