Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Re : Line graph


Hi all,

I have a requirement create line chart as follows.

in my data i have two types of sales private and public.

line graph.PNG

now i want to show the percentage of both out of total sales.How can i acheive this.

if i give separate xpression for both it is showing individual % for public and private.but i want to show out of 100 how much is private and public .

Please suggest.

Regards,

Reena

2 Replies
avinashelite

for the 100% value distribution try like this:

sum(public)/(sum(public)+sum(Private))

similarly

sum(Private)/(sum(public)+sum(Private))

sujeetsingh
Master III
Master III

use filled  line chart style.