topic combo chart with different dates: each line with each date in QlikView

combo chart with different dates: each line with each date

Fri, 30 Nov 2012 16:23:55 GMT

Hi team,

I am trying to create a multichart with four lines (created, closed, resolved and updated) from a list of tickets. I have this data (see the attached image). I create a new combo chart and I configure the following:

dimension 1: Month(created_at) //X axe = Jan, Feb, Mar...

dimension 2: Month(resolved_at) //X axe = Jan, Feb, Mar...

dimension 3: Month(updated_at) //X axe = Jan, Feb, Mar...

dimension 4: Month(closed_at) //X axe = Jan, Feb, Mar...

expression 1: count(created_at)

expression 2: count(resolved_at)

expression 3: count(updated_at)

expression 4: count(closed_at)

But the result is not the expected, of course. I do not know how get for each expression their appropiate month. I stay the whole day trying to fix the problem. Any idea?

Re: combo chart with different dates: each line with each date

Sat, 01 Dec 2012 19:08:44 GMT

first of all...

in combo chart all the expressions have the same dimensions;) (all you can do is prepare combo with two (or more) expressions (one on the left axe and second on the right axe) but it would be still the same dimension for both expressions (the only diference will be teh scale)

as for your question... if all your dimensions give the same range (Jan to Dec) why do you want to use four dimensions? not just one of them? for example Month(created_at) (if task isn't create it could be not resolved/updated/closed, so created_at contain max range of months in your database)

Re: combo chart with different dates: each line with each date

Sun, 02 Dec 2012 00:31:35 GMT

I have one table with all tickets, i.e. 50,000 (see screenshot attached). I want to visualize the amount of created, resolved, closed and updated tickets, per month (Jan...Dec). I decided to use combochart because I want this info all-in-one, i.e. in the same chart. Is possible to do it that I want?