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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.