topic Which is the best chart to create in QlikView

Which is the best chart to create

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Want to know which chart would suit here. I have list of App names and their due dates. Want to create a chart where it shows app names and when(Month-Year) its getting due. attaching the sheet, if someone can create and help me. The app names and due date should be visible in chart

App Names	Due Dates
Intem	4/30/2016
Doxy	5/31/2016
Tabs	6/30/2016
Abc	7/31/2016
BXY	12/1/2016
fing	2/21/2017
Sing	2/28/2017
ABC	3/30/2017
Toots	6/1/2017
systems	9/1/2017

Thanks in advance.

Re: Which is the best chart to create

sunny_talwar — Fri, 22 Jul 2016 15:13:48 GMT

How about a Gantt Chart?

Recipe for a Gantt chart

Re: Which is the best chart to create

sunny_talwar — Fri, 22 Jul 2016 15:15:34 GMT

Well Gantt chart would look nicer if you have a start date associated with each App Name. Do you have this info?

Re: Which is the best chart to create

Anonymous — Fri, 22 Jul 2016 15:36:09 GMT

I have attached the excel. can you please show how to do that

Re: Which is the best chart to create

Anonymous — Fri, 22 Jul 2016 15:39:58 GMT

i only have 1 date..

Re: Which is the best chart to create

sunny_talwar — Fri, 22 Jul 2016 16:14:09 GMT

How about this?

Re: Which is the best chart to create

Anonymous — Fri, 22 Jul 2016 16:35:39 GMT

Thanks Sunny. But not able to understand what the x-axis date means.

Re: Which is the best chart to create

sunny_talwar — Fri, 22 Jul 2016 16:36:40 GMT

It is the date when the App is due, isn't it?

Re: Which is the best chart to create

Anonymous — Fri, 22 Jul 2016 16:39:48 GMT

Thanks.. the bars are small, so i got confused. Is this the best chart to show?

Re: Which is the best chart to create

sunny_talwar — Fri, 22 Jul 2016 16:41:36 GMT

There might be other options, but I am still a learner with visualization. May be marcowedel‌‌ can over his expertise. He usually comes up with unique visuals which I have never ever seen in my life before

Re: Which is the best chart to create

Anonymous — Fri, 22 Jul 2016 16:45:20 GMT

ok thats fine.. Thanks..

Re: Which is the best chart to create

MarcoWedel — Fri, 22 Jul 2016 23:45:08 GMT

Hi Sunny,

thank you.

I don't think I have any special ideas in this case.

Another, quite similar solution to yours, might be to use line chart symbols:

hope this helps

regards

Marco

Re: Which is the best chart to create

Anonymous — Mon, 25 Jul 2016 13:26:22 GMT

Thanks Macro.. As per the data i have the chart looks good.

Re: Which is the best chart to create

sunny_talwar — Mon, 25 Jul 2016 13:28:12 GMT

Great!!! I knew Marco would definitely have something useful for you.

If you got what you wanted, do you mind closing the thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny