Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
jwmonroe
Contributor II

Stacked Bar Chart - Closed vs Open

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?

Tags (2)
1 Solution

Accepted Solutions
jwmonroe
Contributor II

Re: Stacked Bar Chart - Closed vs Open

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

9 Replies
MVP
MVP

Re: Stacked Bar Chart - Closed vs Open

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)

Partner
Partner

Re: Stacked Bar Chart - Closed vs Open

is it possible to post qvw file or sample data ?

sujeetsingh
Honored Contributor III

Re: Stacked Bar Chart - Closed vs Open

Use two dimension one site and then the Status

jwmonroe
Contributor II

Re: Stacked Bar Chart - Closed vs Open

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

jwmonroe
Contributor II

Re: Stacked Bar Chart - Closed vs Open

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

MVP
MVP

Re: Stacked Bar Chart - Closed vs Open

<> in Set Analysis -=

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

jwmonroe
Contributor II

Re: Stacked Bar Chart - Closed vs Open

Manish:

That worked. Thanks a lot.

Jeff

Not applicable

Re: Stacked Bar Chart - Closed vs Open

how will you calculate    open =Findings+Origination

MVP
MVP

Re: Stacked Bar Chart - Closed vs Open

Glad that my answer helped you.

Kindly close this thread by selecting correct answer.