Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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.