topic Re: How To Display Single Month result in Pivot Report in QlikView

How To Display Single Month result in Pivot Report

mohdhaniff — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Can some one help me to modify below script. From the script I able to getresult for 'Disbursement' within range for past 12 mths.

Count({$<[Disbursement]={"$(='>=' & Date(AddMonths(Max([Disbursement]),-11),'DD-MMM-YYYY')

&'<='&Date(Max([Disbursement]), 'DD-MMM-YYYY'))"}>} if(Product='AFFSTR0001', [FS: Account]))

Result:

My Issue:

Now, I wish to have a record with single 'DISBURSED MONTH' only. Therefore I already do the modification by using below script but the result is not the same as earlier script :

Count({$<[Disbursement]={"$(='>=' & Date(AddMonths(Max([Disbursement]),-11),'DD-MMM-YYYY')

&'<='&Date(Max([Disbursement]), 'DD-MMM-YYYY'))"}>}

{$<DISBURSED MONTH={'$(=max(DISBURSED MONTH))'}>} if(Product='AFFSTR0001', [FS: Account]))

Please help me. I believe I miss out some important command in the script that make the total become different with more records.

Regards.

Re: How To Display Single Month result in Pivot Report

Anil_Babu_Samineni — Thu, 23 Feb 2017 03:48:15 GMT

It's difficult to explain and troubleshoot. Would you provide the sample

Try a luck

Count({$<[Disbursement]={"$(='>=' & Date(AddMonths(Max([Disbursement]),-11),'DD-MMM-YYYY')

&'<='&Date(Max([Disbursement]), 'DD-MMM-YYYY'))", [DISBURSED MONTH]={'$(=max([DISBURSED MONTH]))'}}>}

if(Product='AFFSTR0001', [FS: Account]))

Re: How To Display Single Month result in Pivot Report

john9inno — Thu, 23 Feb 2017 03:52:54 GMT

input [] around field name also, i don't think that you need to have below part

[Disbursement]={"$(='>=' & Date(AddMonths(Max([Disbursement]),-11),'DD-MMM-YYYY')

&'<='&Date(Max([Disbursement]), 'DD-MMM-YYYY'))",