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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Separating Data that contains percentage format and numericals in the same field

I have a table that has its field containing numericals and Percentage values. Initially i thought it was alright but i find it hard to plot my chart.

I need some advice on how i can progress from here. I need to display it accordingly as a stack chart

and for the "mean hours per week" in the form of line graph. Do note that i would prefer to keep the table the same.

Some recommendations would be nice. I am really weak with charts.Chart.png

The two tables are arranged to their fields.

Faculty Table.JPG

Programs.JPG

0 Replies