topic Re: trend chart expression error in QlikView

trend chart expression error

Fri, 11 Jul 2014 18:39:47 GMT

Hi,

I'm creating a trend chart, and have 5 months as the dimension. For the expression, I'm trying to find the amount of open or closed incidents, given by the variable "[Incident Status]" and only looking at the closed or open ones. I am using "Count([Incident Status])" to try to get the values, but it is giving me the count total and placing it for each month. How can I get the count of the incidents for that month to show. Thank you.

Re: trend chart expression error

Fri, 11 Jul 2014 19:43:14 GMT

Hi Daniel,

Tough to answer without seeing your data, can you attach an example? If it's giving you the total over 5 months in each month, it sounds like your dates aren't linked properly. Are you using an island calendar? If this were the case, you'd need something like this:

sum(if (IslandDate = DateField, [Incident Status]))

Matt

Re: trend chart expression error

m_woolf — Fri, 11 Jul 2014 19:56:30 GMT

If Incident Status is a variable, that is the reason. You didn't say how Incident Status is defined. I think you might want to create and Incident Status field in script. When you use that field in the expression, the chart should aggregate the count for the months.