how to show data in %

[#1]

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

[#2]

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??

[its_anandrjs]

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) )

[Anonymous]

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.

[#5]

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.

[tresesco]

Dear Yogita,

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

[#7]

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