topic Re : Line graph in QlikView

Re : Line graph

Thu, 08 Oct 2015 07:42:29 GMT

Hi all,

I have a requirement create line chart as follows.

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

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

Re: Re : Line graph

avinashelite — Thu, 08 Oct 2015 07:48:39 GMT

for the 100% value distribution try like this:

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

similarly

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

Re: Re : Line graph

sujeetsingh — Thu, 08 Oct 2015 07:49:33 GMT

use filled line chart style.