topic Creating a Chart in QlikView

Creating a Chart

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

Hi,

I am a bit stuck with the below problem. My Data looks like the below :

Code Name Category Mon Tue Wed Thu Fri

123 ABC ABC 0.2 0.36 0.45 125 256

Thus, when I read this data into the script, the days (Mon-Fri) are fields.

What i would like recreate is the below:

I created a field that Checks if the category are like '*Franchise','* corporate' etc.

But when I have the categories as Dimension and AVG of the days as expressions, the below is seen.

Please share some ideas of how i can get it as the above graph.

Thanks in advance!

Re: Creating a Chart

ahaahaaha — Thu, 16 Mar 2017 06:57:56 GMT

Hi Ruan,

Can the following table conversion help?

CrossTable(DayWeek,Volume, 3)

LOAD*Inline

[Code,Name,Category,Mon,Tue,Wed,Thu,Fri

123,ABC,ABC,0.2,0.36,0.45,125,256];

Result

Regards,

Andrey

Re: Creating a Chart

Anonymous — Thu, 16 Mar 2017 07:17:33 GMT

Hi Andrey,

You gave me the right idea with the cross table, so i used the transpose step in order to get the data, as this data was available in the Spreadsheet i use it from.

Thanks

Re: Creating a Chart

rahulpawarb — Thu, 16 Mar 2017 07:27:26 GMT

Hello Ruan,

Please refer the attached sample application.

Regards!

Rahul

Re: Creating a Chart

Anonymous — Thu, 16 Mar 2017 08:18:03 GMT

Thanks Rahul,

Please could you tell me how you got the data points to be circles ? I cant seem to find that option anywhere.

Regards,

Re: Creating a Chart

rahulpawarb — Thu, 16 Mar 2017 08:55:40 GMT

Hello Ruan,

In the expression tab, under the Display Options tick the Symbol option and set as Dots (refer the attached screenshots). Repeat this for every expression. Once this is done then change the Symbol Size to 6 pt from Line/Symbol Settings available under Presentation tab.

Regards!

Rahul

Re: Creating a Chart

Anonymous — Fri, 17 Mar 2017 04:38:04 GMT

Many thanks!