Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

Re: Bar Chart with two columns

Hi,

PFA,

Regards

Rajesh Kumar

Highlighted
Partner
Partner

Re: Bar Chart with two columns

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

Highlighted
Creator
Creator

Re: Bar Chart with two columns

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])

Highlighted
MVP & Luminary
MVP & Luminary

Re: Bar Chart with two columns

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.

Highlighted
Not applicable

Re: Bar Chart with two columns

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

Highlighted
Not applicable

Re: Bar Chart with two columns

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.

Highlighted
Not applicable

Re: Bar Chart with two columns

Hi,

PFA.

HTH.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Bar Chart with two columns

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.

Highlighted
Not applicable

Re: Bar Chart with two columns

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.