topic Re: how to show data in % in QlikView

how to show data in %

Sat, 21 Jun 2014 05:13:43 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.

want some expression like this when i will click on month then it will show month wise data and when i will drill down by airlines dn it should data and percentage of share in total month data ?

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 %

Sat, 21 Jun 2014 19:21:25 GMT

Hi,

PFA, qvw with test data.

Re: how to show data in %

maxgro — Sat, 21 Jun 2014 21:24:37 GMT

add an expression to bar chart and only check value on data point

use num to format and total for %

num (sum(data), '#.##0') & ' (' & num(sum(data) / sum(TOTAL <month> data), '#.##0,0%') & ')'

num (sum(data), '#.##0') & ' (' & num(sum(data) / sum(TOTAL data), '#.##0,0%') & ')'

num (sum(data), '#.##0') & ' (' & num(sum(data) / sum(TOTAL <airline> data), '#.##0,0%') & ')'

Re: how to show data in %

ashfaq_haseeb — Sun, 22 Jun 2014 07:12:43 GMT

Hi,

Look at the attached application.

Regards

ASHFAQ

Re: how to show data in %

suniljain — Sun, 22 Jun 2014 14:59:07 GMT

You can use sum(data)/Sum(total data)

Re: how to show data in %

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