Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar Chart with two columns

Hi Guys, i am very new to qlikview and wondering how to create a bar chart with 1 dimension and 2 expressions. The dimension represents year and first expression represents total number of tickets and second expression represents total number of closed tickets. I was able to show up the total number of tickets but struggling to get the second bar. Not sure if there is any straight method to count the closed tickets using status field. My sample data is as follows:

Image 1.png

Thank you in advance.

11 Replies
rajeshforqlikvi
Creator
Creator

Hi,

PFA,

Regards

Rajesh Kumar

Anonymous
Not applicable
Author

Hi,

for the second expression to count the closed tickets, just do this in the set analysis:

count({<Status={'Closed'}>} DISTINCT Incident Number)


The above just returns the number of closed tickets only

Anonymous
Not applicable
Author

Hi,

This may help you

PFA , sample application

use Set analysis or If statement to Find Closed Ticket,

Dimension : Year

1) Expression - Count( Distinct Incident Number)

2) Expression  =Count({<Status={'Closed'}>} [Incident Number])

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Dimension: Year

Expression:

Total Tickets: Count(Distinct [Incident Number])

Close Tickets: Count({<Status={'Closed'}>}Distinct [Incident Number])

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

Hi Aru,

load * inline [

reportedate,status

2016,open

2015,open

2014,open

2016,open

2015,open

2014,open

2016,open

2015,close

2014,close

2016,close

2015,close

2014,close

2011,close

2010,open

2015,open

];

Untitled.png

Not applicable
Author

Hi Raman,

Sorry i do not understand how the load* works. Also not sure why you are repeating the Open and Close 3 times for each year. May i know the rational or how these works? Thank you so much for your reply.

Not applicable
Author

Hi,

PFA.

HTH.

jagan
Luminary Alumni
Luminary Alumni

HI,

Did you tried this

Dimension: Year

Expression:

Total Tickets: Count(Distinct [Incident Number])

Close Tickets: Count({<Status={'Closed'}>}Distinct [Incident Number])

Hope this helps you.

Regards,

Jagan.

Not applicable
Author

Hi Jagan, yes it works. Previously i tried with  Count({ $ < Status = {‘Closed’} > }  [Incident Number]) but didnt work. What is the meaning of $ sign in the expression? Any way thank you and all the supporters.