Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
PFA,
Regards
Rajesh Kumar
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
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])
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.
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
];
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.
Hi,
PFA.
HTH.
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.
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.