Expression not returning required results

[deepakqlikview_123]

Hi All,

PFA

As per requirement if FRQ_Type is A then i need to show Q4 data for FRQ_TYPE A,otherwise need to put Q4 data for FRQ type Q

for indicator and its respective value as per country.

but below expression is not returning perfect result

if(MinString(FRQ_TYPE)='A',Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},COUNTRY={'Singapore'},FRQ_TYPE={'A'},QUARTER={'Q4'}>}INDICATOR_VALUE),

Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},COUNTRY={'Singapore'},FRQ_TYPE={'Q'},QUARTER={'Q4'}>}INDICATOR_VALUE))

Please suggest on this.

Thanks

[deepakqlikview_123]

Hi All,

Can you please suggest on this.

Thanks

[sunny_talwar]

What is the expected output?

[deepakqlikview_123]

As per requirement if FRQ_Type is A then i need to show Q4 data for FRQ_TYPE A,otherwise need to put Q4 data for FRQ type Q

seems minstring also not working.

[sunny_talwar]

So for any particular year, if A is available use that and if not use Q?

[deepakqlikview_123]

yes

but if Q is present use Q4

[sunny_talwar]

If it is not present then???

[deepakqlikview_123]

if FRQ_Type is A then i need to show Q4 data for FRQ_TYPE A,otherwise need to put Q4 data for FRQ type Q

[CELAMBARASAN]

Try simply

Avg({<INDICATOR_NAME={'% of Non-Bank Private Debt to Nominal GDP'},COUNTRY={'Singapore'},FRQ_TYPE={'A','Q'},QUARTER={'Q4'}>}INDICATOR_VALUE)

[deepakqlikview_123]

still it is not working