topic Re: Chart to map some items depending on dimensions in QlikView

Chart to map some items depending on dimensions

Mon, 15 Apr 2013 12:39:55 GMT

Is it possible to create a chart like the one i put in attachment ?

I don't think it is possible, but I know that QlikView can be sometimes surprising !

Re: Chart to map some items depending on dimensions

Anonymous — Mon, 15 Apr 2013 15:05:18 GMT

I don't think you can have the same exact presentation (unless you build an extension for this), but you can get the same logic using pivot table or maybe grid chart. For pivot, can use expression like
concat (distinct Project, chr(13)).

Regards,

Michael

Re: Chart to map some items depending on dimensions

Thu, 18 Apr 2013 12:07:48 GMT

Hi Michael,

Thank you for your quick reply.

Indeed using a pivot table is a start, even if it is not very sexy.

I suppose it is not possible to change the size of the font of each Project according to a dimension, or but each project inside a a shape with a color according to another dimension etc...

Concerning the grid chart, I really have no idea how to do it.

Regards,

Yannick

Re: Chart to map some items depending on dimensions

kaushiknsolanki — Thu, 18 Apr 2013 13:21:55 GMT

Hi,

Have a look at the attachment.

Here find the Relationship Tab where there is an example of the grid chart.

Hope this will give you some idea.

Regards,

Kaushik Solanki

Re: Chart to map some items depending on dimensions

Thu, 18 Apr 2013 15:20:19 GMT

Hi Kaushik,

Thanks for your rely

Indeed this is helping, because this type of charts is the type I never use and therefore I don't really know how to use it.

I have been able to work on my project, but I still can't make it perfect.

I have created a simple qvw file to present what I want and what i have managed to do.

If someone very kind want to help me you can find it attachment !!!

Thank you !!!

Re: Chart to map some items depending on dimensions

Anonymous — Thu, 18 Apr 2013 21:11:33 GMT

I've added two charts to your example - pivot and another version of gid. Not yet your dream, sorry.

Re: Chart to map some items depending on dimensions

Thu, 18 Apr 2013 22:24:11 GMT

Here's another variation.

Re: Chart to map some items depending on dimensions

Fri, 19 Apr 2013 08:24:47 GMT

Hi,

Thank you both for your help

Unfortunately I'm still running QV Personnal Edition, and am waiting for my license, so I can't open your qvw files yet.

But I will get back to you as soon as I open them.

Re: Chart to map some items depending on dimensions

Mon, 15 Jul 2013 13:27:55 GMT

Hi,

I come back to you all to share what I have done

After thinking it through, I managed to do that

(in case it can help anybody) !

see attached

thanks for your help folks !