Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

combo chart with different dates: each line with each date

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?

2 Replies
Not applicable
Author

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)

Not applicable
Author

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?