Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

counts

HI All,

PLease find the attahcment of the QVW file and Excel file.

I have a bar chart  which will show the values of created and closed  tickets each month respectively ...

count of created is showing properly but Count of Closed is adding up everything...

i need to chow the count of closed for the selected month only which  should be like , if the entry is missing in closed date the it should consider the count of resolved that for that perticular month

only.

For example:

slelect Level = Low For Feb-2017 open is giving the correct value which is 59 ... and close value is showing wrong as 40 , which should be 16 that is sum of closed and resolved tickets only for Feb-2017 (selected month)

thanks in advance

10 Replies
antoniotiman
Master III
Master III

John,

40 is correct

28 Count(Closed) + 12 IsNull(Closed) with Resolved

Regards,

Antonio