topic Re: bar graph in QlikView

bar graph

Mon, 08 Sep 2014 10:11:54 GMT

Hi all,

In my bar graph, how can i show the values and percentage both together on bar.(By using values on data point)

thanks

Re: bar graph

MK_QSL — Mon, 08 Sep 2014 10:19:40 GMT

Consider you have Customer, Sales and Purchase data...

Create a Bar Chart

Dimension

Customer

Expressions

1) SUM(Sales)

Tick Bar and Untick Values on Data Points

2) 'Sales : '&SUM(Sales) & CHR(10) & NUM((SUM(Sales)-Sum(Purhcase))/SUM(Sales),'#,##0.00%')

Untick Bar Chart

Tick Values on Data Points

Change Dimension and Expressions according to your database and requirements..

Re: bar graph

Mon, 08 Sep 2014 10:56:39 GMT

thanks for effort but i couldnt follow..

can u help with simple solution

thanks

Re: Re: bar graph

ashfaq_haseeb — Mon, 08 Sep 2014 11:03:13 GMT

Hi,

Have a look at attached application.

Regards

ASHFAQ

Re: Re: bar graph

MK_QSL — Mon, 08 Sep 2014 11:05:04 GMT

Check enclosed file...

Re: bar graph

engishfaque — Mon, 08 Sep 2014 11:08:53 GMT

Dear Deepak,

Chart Properties > Expressions > Check to "Relative" Check box.

Kind regards,

Ishfaque Ahmed

Re: bar graph

MarcoWedel — Mon, 08 Sep 2014 11:13:48 GMT

Hi,

one solution:

hope this helps

regards

Marco

Re: bar graph

Mon, 08 Sep 2014 11:35:21 GMT

i cant understand the expression

Re: bar graph

MK_QSL — Mon, 08 Sep 2014 11:54:23 GMT

Dual Function will have two values...
Dual(A,B).... A is Text and B is Numeric

Sum(Sales) & Chr(10) & Num(Sum(Sales) / Sum(Total Sales),'##0.0%') Text

need to divided into

Sum(Sales) ==> Total Sales for each Category

Sum(Sales) / Sum(Total Sales) ==> Total Sales for each Category / Total Sales

Num(Sum(Sales) / Sum(Total Sales),'##0.0%') ==> Convert above in to %

Chr(10) will make another line./ New Line Feed...

Sum(Sales) Numeric

Hope this helps....