topic Re: how to show data in % in QlikView

how to show data in %

Fri, 20 Jun 2014 11:40:55 GMT

hi i have a bar graph in drill down .

first dimension is month and second is airline .

when i drill down that then airline wise revenue is coming .

i'm using sum(data) expression.

i just want it will show revenue airline wise and % share of revenue in total month revenue.

could you please help ???

like this i want to show

Re: how to show data in %

alexandros17 — Fri, 20 Jun 2014 11:46:24 GMT

try this

Sum(data) / Sum(total <month> data)

let me know

Re: how to show data in %

Fri, 20 Jun 2014 11:57:09 GMT

no this is not the solution.

there should be some expression that will show data and percentage..

as u r seeing in graph i showed.

Re: how to show data in %

Fri, 20 Jun 2014 11:57:40 GMT

please help?

Re: how to show data in %

MayilVahanan — Fri, 20 Jun 2014 11:59:12 GMT

Try like this

= Sum(Total1) & ' '& Num(Sum(Total1) / Sum(total [Total1]),'#.##%') &''

Re: how to show data in %

alexandros17 — Fri, 20 Jun 2014 12:05:23 GMT

So your problem is not How to compute but how to show value and percentage

If this is correct, I tell you that this is not possible because you have no control on value on data points ...

Re: how to show data in %

Fri, 20 Jun 2014 12:11:48 GMT

both are my problem .. this is not working

Re: how to show data in %

alexandros17 — Fri, 20 Jun 2014 12:23:57 GMT

Could you send your document?

Re: how to show data in %

Sat, 21 Jun 2014 04:15:52 GMT

Hi ,

Any solution for this ??

Re: how to show data in %

its_anandrjs — Sat, 21 Jun 2014 05:14:00 GMT

Use Dual function for this. See with small example to understand

Load * inline

[

Customers,Sales

Ghanna,152450

Jersey,154702

Newzealand,45826

];

And on the chart

Dimension:- Customers

Expression:- Sum(Sales)

Expression:- Dual( Customers & ' - ' & sum(Sales),

Sum(Sales) / Sum(TOTAL Sales) )

Re: how to show data in %

Sat, 21 Jun 2014 05:22:45 GMT

yes there will be function like this..

=dual(num(sum({<FiscalYearName={'$(vFCY)'},FisQuarter=,FiscalMonth=,Day=>}

IF(Date<= vMaxDate,data)),'##0.00')&' ('&num(sum({<FiscalYearName={'$(vFCY)'},FisQuarter=,FiscalMonth=,Day=>}

IF(Date<= vMaxDate,data))/sum(TOTAL {<FiscalYearName={'$(vFCY)'},FisQuarter=,FiscalMonth=,Day=>}

IF(Date<= vMaxDate ,data)),'0.0%')&')',

sum({<FiscalYearName={'$(vFCY)'},FisQuarter=,FiscalMonth=,Day=>} IF(Date<= vMaxDate,data)))

but any1 can help me exact expression??

Re: how to show data in %

its_anandrjs — Sat, 21 Jun 2014 06:00:40 GMT

Try this way

=Dual(Month&'-'& Sum({<FisQuarter=,

FiscalMonth=,

Day=,

FiscalYearName={'$(vFCY)'},

Date = {'<=$(=vMaxDate)'}>} data),

Sum({<FisQuarter=,

FiscalMonth=,

Day=,

FiscalYearName={'$(vFCY)'},

Date = {'<=$(=vMaxDate)'}>} data)

Sum(TOTAL {<FisQuarter=,

FiscalMonth=,

Day=,

FiscalYearName={'$(vFCY)'},

Date = {'<=$(=vMaxDate)'}>} data) )

Re: how to show data in %

Anonymous — Sat, 21 Jun 2014 07:09:56 GMT

You will need to go to graph properties.

Then go to Expressions

Select the Expression you want

There is a option called "Relative". Tick this option and press ok

Take a look at this example:

http://community.qlik.com/servlet/JiveServlet/showImage/2-277360-24631/QV3.png

If you still need help, please post your sample.

Re: how to show data in %

Mon, 23 Jun 2014 04:47:39 GMT

please understand my question i want to use drill down .. and to show data firstly on monthwise dn after drill down it will show the data airline wise and its total % assosicated in month data.

Re: how to show data in %

tresB — Mon, 23 Jun 2014 05:12:47 GMT

Dear Yogita,

I would suggest you to create a sample qvw with sample inline data and explain the expected output there and share here.

Re: how to show data in %

Mon, 23 Jun 2014 06:06:40 GMT

i have attached a sample QVW file with original post and see wat i exactly want