topic To Show data like in percentage in QlikView

To Show data like in percentage

Sat, 21 Jun 2014 05:07:02 GMT

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: To Show data like in percentage

Sun, 22 Jun 2014 11:46:21 GMT

- Create a variable to store the % calculations

* v% = 100*(aggr(sum(Qty),Invoice #)/sum(Qty)

- Add another expression and add the below as definition

sum(Qty)&' ('& v% &')'

- Untick Bar in the Data option

- Tick Value on Data points

Hope this makes sense.

I have a sample file on personal edition not sure if you can open this

Note: Please check fields names match with the field names on your file

Thanks and

Padma

Re: To Show data like in percentage

Mon, 23 Jun 2014 04:47:16 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.