topic Re: Percentage help in QlikView

Percentage help

Fri, 25 Sep 2015 18:52:09 GMT

Hi All,

I have one requirement. I have one table which contains Year,Half Year, Type,Amount.

Here i need to view data as $(Dollar) and %(Percentage).

For this i have created two buttons. If i click on $ values should be devided by 60 and if i

click on % value should be devided by Gross (one of 'Type' value).

But here i need to display % as 100% in both years.

Ex : For 2014 year Gross is 2200.

so % should be 2200/2200 = 100% for Gross, 850/2200 = 38.6% for Disc,1350/2200 = 61.4% for NonDisc

But i am getting values as 2200/3300(2014+2015 Gross Sum) = 100% for Gross,850/3300 = 25.8% for Disc,1350/3300 = 40.9% for NonDisc.

If i drill down to half year then Gross % should be 100% for all Half Years means it should consider Gross amount for particular Half year but not total Gross.

I am attaching sample QVW also here. Could you please somebody help me here.

Thanks in advance,

QV User

Re: Percentage help

Fri, 25 Sep 2015 19:41:13 GMT

there are a few items I do not understand

when I look at your chart by year, the dollar amount for gross shows 36.7 for 2014 and 18.3 for 2015 but the actual dollar amounts are 2200 and 1100 respecitively

If I click on %, it converst each each year by type to a percent and the Gross is the only one that adds up to 100% across the years

If I create a list box with the period dimension and select 2014, the percentage for 2014 is the same as it was for both years, it just shows 2014. When I click on the % option, it convertes to correct percent

also for 2015, you have gross of 100 but a discount of 2250, which would make your % of discount grreater than 100% - non-discount is the same - shouldnt discount and non-discount add up to gross

Re: Percentage help

ecolomer — Fri, 25 Sep 2015 20:46:32 GMT

Is this ??

Re: Percentage help

qlikviewwizard — Sat, 26 Sep 2015 01:37:01 GMT

Hi,

Is this you want?

Re: Percentage help

Sat, 26 Sep 2015 05:18:38 GMT

Hi All,

Expected result as below:

If it is year then as follows:

Type	Year	2014	2015
Gross		100%	100%
Disc		38.60%	41.30%
NonDisc		61.40%	58.70%

If we drill down to Half year then as follows:

Type	Half Year	2014H1	2014H2	2015H1	2015H2
Gross		100%	100%	100%	100%
Disc		40%	37.50%	50%	33.40%
NonDisc		60%	62.50%	50%	66.60%

I have attached updated QVW also. Please somebody give me some suggestion here.

Thanks,

QV11 User

Re: Percentage help

Sat, 26 Sep 2015 05:19:47 GMT

Hi Adam,

I have updated QVW and added to arjun rao's reply below.

Could you please take a look into this?

Thanks,

QV11 User