Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmeplease
Creator III
Creator III

Creating a Chart

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:

22222.JPG

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!

44444.JPG

1 Solution

Accepted Solutions
rahulpawarb
Specialist III
Specialist III

Hello Ruan,

Please refer the attached sample application.

Regards!

Rahul

View solution in original post

6 Replies
ahaahaaha
Partner
Partner

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

6.jpg

Regards,

Andrey

qlikmeplease
Creator III
Creator III
Author

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

rahulpawarb
Specialist III
Specialist III

Hello Ruan,

Please refer the attached sample application.

Regards!

Rahul

View solution in original post

qlikmeplease
Creator III
Creator III
Author

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,

rahulpawarb
Specialist III
Specialist III

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

qlikmeplease
Creator III
Creator III
Author

Many thanks!