topic Re: Urgent Help needed in expression in QlikView

Urgent Help needed in expression

Mon, 04 Aug 2014 02:12:35 GMT

I am facing some calculation issues in Pivot table .

i need the chart to be as in the pic

i am sharing the excel sheet and QVW for the reference.

So, kindly help me out to resolve the issues for the expression

Re: Urgent Help needed in expression

Anonymous — Mon, 04 Aug 2014 02:46:55 GMT

Hi,

Are you looking "P-Rate QTD" as a part of your expression? You may try below,

=IF(Match(ServiceOLR.TYPE,'Budget', 'Actuals', 'P-Rate QTD'), NUM(SUM(ServiceOLR.AMOUNT), '#,##0'),

IF(Match(ServiceOLR.TYPE,'Actuals %'),

Num(SUM({1< ServiceOLR.TYPE = {'Actuals'}>} total <ServiceOLR.SUB_REGION, ServiceOLR.COUNTRY, ServiceOLR.PL> ServiceOLR.AMOUNT) /

SUM({1< ServiceOLR.TYPE = {'Budget'} >} total <ServiceOLR.SUB_REGION, ServiceOLR.COUNTRY, ServiceOLR.PL> ServiceOLR.AMOUNT), '#,##0%')))

Re: Urgent Help needed in expression

Mon, 04 Aug 2014 02:52:31 GMT

Yes

i got it but my query lies in if i select in filters the values in "Actuals %" are not changing , but actually values are to be changed as per the source Excel sheet.

Do help me in that way

Re: Re: Urgent Help needed in expression

Anonymous — Mon, 04 Aug 2014 03:12:10 GMT

Hi,

I could see the data changes in Actual % after doing filtration and even it is matching with excel. I just uploaded excel you attached. See updated qvw attachment.

Re: Urgent Help needed in expression

Mon, 04 Aug 2014 03:44:48 GMT

Satyadev

Thanks for your response

unfortunately i cannot see changes as per the filterations on the Accounts% column

anyways i got the solution .

Thanx for your support