topic Re: Bar Chart with two columns in QlikView

Bar Chart with two columns

Thu, 28 Jan 2016 02:25:28 GMT

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:

Thank you in advance.

Re: Bar Chart with two columns

rajeshforqlikvi — Thu, 28 Jan 2016 07:59:53 GMT

Hi,

PFA,

Regards

Rajesh Kumar

Re: Bar Chart with two columns

Anonymous — Thu, 28 Jan 2016 08:21:00 GMT

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

Re: Bar Chart with two columns

Anonymous — Thu, 28 Jan 2016 08:29:03 GMT

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

Re: Bar Chart with two columns

jagan — Thu, 28 Jan 2016 08:29:42 GMT

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.

Re: Bar Chart with two columns

Thu, 28 Jan 2016 08:42:00 GMT

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

];

Re: Bar Chart with two columns

Thu, 28 Jan 2016 08:56:42 GMT

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.

Re: Bar Chart with two columns

Thu, 28 Jan 2016 08:57:42 GMT

Hi,

PFA.

HTH.

Re: Bar Chart with two columns

jagan — Fri, 29 Jan 2016 00:15:20 GMT

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.

Re: Bar Chart with two columns

Fri, 29 Jan 2016 01:04:18 GMT

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.

Re: Bar Chart with two columns

jagan — Fri, 29 Jan 2016 01:13:05 GMT

HI,

If you got the Answer please close this thread by giving Correct Answer to the post which helps you in finding the answers.

Regards,

jagan.

Re: Bar Chart with two columns

jagan — Fri, 29 Jan 2016 02:18:57 GMT

Hi,

$ means Current Selections, $ is not a mandatory one.

If you got the answer close this thread by giving Correct Answers to the post.

Regards,

Jagan.