Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
thomaswrieck
Partner
Partner

Total Open Tickets per Day - Barchart

Hello,

I need an Idea/Solution for the following ...

A barchart should show the total amount of Open Tickets per day (actually for other timevalues as well like week or month).

Screenshot.JPG

The formula I use right now doesn't show correct values for the first bar in the chart. For all other days e.g. the correct values will be shown.

Any Idea/Solution to show the correct value for the first bar as well would be welcome.

Thanks a lot ...

Thomas

7 Replies
swuehl
MVP
MVP

Try to create an interval using your single dates records, then create reference dates for each ticket and use the reference date as dimension for your open count:

Creating a Date Interval from a Single Date

Creating Reference Dates for Intervals

thomaswrieck
Partner
Partner
Author

well ... these concepts doesn't help here ....

mvanlutterveld
Partner
Partner

Hi Thomas,

Something like this?

Cheers,

Michiel

ThornOfCrowns
Specialist II
Specialist II

Are you expecting each bar to show 2, i.e. count(Status) - [New Tickets]?

swuehl
MVP
MVP

Thomas Rieck <span class="icon-status-icon icon-partner" title="Partner"></span> wrote:

well ... these concepts doesn't help here ....

Why not? Isn't the chart that Henric showed in his reference date blog post exactely what you would like to see?

Just link a Master Calendar to the reference date field and you can show your open tickets by Date, Week, Month etc. easily.

thomaswrieck
Partner
Partner
Author

I think I need do something like this ...

Screenshot2.JPG

and do a count on the target format table .... actually I wanted to avoid that since I produce more datasets ...

swuehl
MVP
MVP

To me it looks like this is the right path (and btw, this is what the blog posts describe.

For the Open tickets, I think you should fill in a CloseDate like Today().

Again, it's all pretty well explained in the two blog posts and the referenced tech doc.