topic Re: Expression not working in QlikView

set analysis issue

deepakqlikview_123 — Mon, 08 Jun 2015 12:14:30 GMT

Hi All,

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 one particular year

But after appyling if else condition in set analysis below expression is not working

if(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))

plz suggest on this.

Thanks

Re: Expression not working

sushil353 — Mon, 08 Jun 2015 12:18:50 GMT

Hi,

What issue are u getting.. if possible share sample app.

Re: Expression not working

deepakqlikview_123 — Mon, 08 Jun 2015 12:25:26 GMT

Please find attached sample application for this

Re: Expression not working

Kushal_Chawda — Mon, 08 Jun 2015 12:36:10 GMT

What if FRQ_TYPE is other than A or Q?

Re: Expression not working

rubenmarin — Mon, 08 Jun 2015 13:02:17 GMT

Hi Deepak, the first "if" will return several values for each year, so it will return null and the "if" will go (almost) always for the "else", try with this expression:

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))

Re: Expression not working

Peter_Cammaert — Mon, 08 Jun 2015 13:21:22 GMT

There are 5 years (2005-2009) that have both A and Q values for FRQ_TYPE. What do you want to do for those? Select FRQ_TYPE=A like Ruben suggests? In that case I think you better store FRQ_TYPE in your calendar so that it becomes a real dimension value tied to a particular year. As a result, your original expression will suddenly start to work.

And you can omit the IF clause and FRQ_TYPE={'A'} or {'Q'} modifier from your set spec. Makes things a lot simpler.

Peter.

Re: Expression not working

deepakqlikview_123 — Mon, 08 Jun 2015 14:14:15 GMT

hi peter

if FRQ type A is present then i need to put value for A otherwise need to show value for FRQ_TYPE Q for Q4

Can you please suggest how shall i go ahead in back end.

Thanks

Re: Expression not working

deepakqlikview_123 — Mon, 08 Jun 2015 14:29:33 GMT

Thanks Marin,

It is working fine initially.But after selecting FRQ type Q it represnets all values for FRQ type Q which is not required if FRQ type A present,if FRQ type A is not present then only i need to show value for FRQ type Q

thanks

Re: Expression not working

rubenmarin — Mon, 08 Jun 2015 14:33:52 GMT

Maybe ignoring selections when checking FRQ:

if(MinString({1} 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))

Re: Expression not working

deepakqlikview_123 — Thu, 11 Jun 2015 16:54:45 GMT

hi,

Still it is not working for else part when all data is present.

thamks