topic Re: Expression not returning required results in QlikView

Expression not returning required results

deepakqlikview_123 — Thu, 11 Jun 2015 14:42:40 GMT

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

Re: Expression not returning required results

deepakqlikview_123 — Thu, 11 Jun 2015 17:43:50 GMT

Hi All,

Can you please suggest on this.

Thanks

Re: Expression not returning required results

sunny_talwar — Thu, 11 Jun 2015 17:44:48 GMT

What is the expected output?

Re: Expression not returning required results

deepakqlikview_123 — Thu, 11 Jun 2015 17:55:43 GMT

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.

Re: Expression not returning required results

sunny_talwar — Thu, 11 Jun 2015 17:57:12 GMT

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

Re: Expression not returning required results

deepakqlikview_123 — Thu, 11 Jun 2015 17:58:13 GMT

yes

but if Q is present use Q4

Re: Expression not returning required results

sunny_talwar — Thu, 11 Jun 2015 18:00:11 GMT

If it is not present then???

Re: Expression not returning required results

deepakqlikview_123 — Fri, 12 Jun 2015 05:22:59 GMT

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

Re: Expression not returning required results

CELAMBARASAN — Fri, 12 Jun 2015 05:42:51 GMT

Try simply

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

Re: Expression not returning required results

deepakqlikview_123 — Fri, 12 Jun 2015 06:45:21 GMT

still it is not working