topic Re: Stacked Bar Chart - Closed vs Open in QlikView

Stacked Bar Chart - Closed vs Open

jmonroe918 — Mon, 24 Feb 2014 06:27:11 GMT

I am creating a stacked bar chart that will display a list of Sites as my dimension and whether the site has open vs closed Status of Audits performed. There is a "closed" status and then there are several "open" status. What expressions do I use for the two parts of the stacked bars?

Re: Stacked Bar Chart - Closed vs Open

MK_QSL — Mon, 24 Feb 2014 06:37:32 GMT

Let us know the dimensions related to your questions.

Also, are you going to count number of sited open or close?

Let me give you an example which will give you count of Orders by date...

Dimension = Date

Expression 1 = COUNT({<OrderStatus = {'Open'}>}OrderID)

Expression 2 = COUNT({<OrderStatus = {'Close'}>}OrderID)

Re: Stacked Bar Chart - Closed vs Open

manojkulkarni — Mon, 24 Feb 2014 06:37:41 GMT

is it possible to post qvw file or sample data ?

Re: Stacked Bar Chart - Closed vs Open

sujeetsingh — Mon, 24 Feb 2014 06:38:31 GMT

Use two dimension one site and then the Status

Re: Stacked Bar Chart - Closed vs Open

jmonroe918 — Mon, 24 Feb 2014 15:03:45 GMT

Manish:

Thanks for the response. It think the expressions you created are what I need, however Expression 1 needs to be any record that is not 'Closed'. There are other statuses (Originiation, Investigation, etc). How do I work the modifhier to exclude "Closed". Here are my expressions:

Closed audits:

= COUNT({<[Internal Audits.Status] = {'Closed'}>}[Internal Audits.Audit No])

Open (not closed) audits

= COUNT({<[Internal Audits.Status] - {'*Closed*'}>}[Internal Audits.Audit No])

I'm getting an error in the second expression.

Thanks.

Jeff

Re: Stacked Bar Chart - Closed vs Open

jmonroe918 — Mon, 24 Feb 2014 15:16:04 GMT

Manish:

I couldn’t figure out how to attach the file, so I decided to email it to you until I figure it out.

Thanks.

Jeff

Re: Stacked Bar Chart - Closed vs Open

MK_QSL — Mon, 24 Feb 2014 15:37:14 GMT

<> in Set Analysis -=

= COUNT({<[Internal Audits.Status] -= {'Closed'}>}[Internal Audits.Audit No])

Re: Stacked Bar Chart - Closed vs Open

jmonroe918 — Tue, 25 Feb 2014 06:08:36 GMT

Manish:

That worked. Thanks a lot.

Jeff

Re: Stacked Bar Chart - Closed vs Open

Tue, 25 Feb 2014 06:16:11 GMT

how will you calculate open =Findings+Origination

Re: Stacked Bar Chart - Closed vs Open

MK_QSL — Tue, 25 Feb 2014 06:57:01 GMT

Glad that my answer helped you.

Kindly close this thread by selecting correct answer.