topic Re: Expression help in QlikView

Expression help

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

Hi,

I have the following expression and I can't seem to get it to work:

=If(strategy_ref = 'Physical' and Count(trade_type_group_cd ='Future',trade_num)>0 and compliance_checked_flg ='N','Y','N')

It would be much appreciated if someone could point out where I am going wrong.

Regards,

Daniel

Re: Expression help

Anil_Babu_Samineni — Thu, 01 Feb 2018 14:55:31 GMT

Try this

=If(strategy_ref = 'Physical' and Count({<trade_type_group_cd ={'Future'}>} trade_num)>0 and compliance_checked_flg ='N','Y','N')

Re: Expression help

ali_hijazi — Thu, 01 Feb 2018 14:56:20 GMT

it seems you don't know the set analysis syntax

but where are you writing this in script or on chart

if on chart then you need to write your expression as follows:

if(strategy_ref = 'Physical' and count({<trade_type_group_cd={'Future'>}trade_num) >0 and compliance_checked_flg='N' ,'Y','N')

Re: Expression help

danielnevitt — Thu, 01 Feb 2018 15:05:40 GMT

Hi Anil/Ali,

Thank you both for your help. That now works perfectly.

Are you able to help with adding the below:

=If(strategy_ref = 'Physical' and Count({<trade_type_group_cd ={'Future'}>} trade_num)>0 and compliance_checked_flg ='N','Y','N') or
If(strategy_ref = 'Hedge' and Count({<trade_type_group_cd ={'Physical'}>} trade_num)=0 and compliance_checked_flg ='N','Y','N') or
If(strategy_ref = 'Trading' and Count({<trade_type_group_cd ={'Physical'}>} trade_num)>0 and compliance_checked_flg ='N','Y','N')

Regards,

Daniel

Re: Expression help

Anil_Babu_Samineni — Thu, 01 Feb 2018 15:10:37 GMT

Yes, I can help you here

=If((strategy_ref = 'Physical' and Count({<trade_type_group_cd ={'Future'}>} trade_num)>0 and compliance_checked_flg ='N') or (strategy_ref = 'Hedge' and Count({<trade_type_group_cd ={'Physical'}>} trade_num)=0 and compliance_checked_flg ='N') or (strategy_ref = 'Trading' and Count({<trade_type_group_cd ='Physical'}>} trade_num)>0 and compliance_checked_flg ='N')

,'Y','N')

Re: Expression help

danielnevitt — Thu, 01 Feb 2018 17:11:26 GMT

Hi Anil,

Thank you for your help, that all worked perfectly.

As a last favour, would it be possible to explain how to use the code in the LOAD statement?

Regards,

Daniel

Re: Expression help

Anil_Babu_Samineni — Fri, 16 Feb 2018 15:09:25 GMT

Why not calling as field name?

If((strategy_ref = 'Physical' and Count({<trade_type_group_cd ={'Future'}>} trade_num)>0 and compliance_checked_flg ='N') or (strategy_ref = 'Hedge' and Count({<trade_type_group_cd ={'Physical'}>} trade_num)=0 and compliance_checked_flg ='N') or (strategy_ref = 'Trading' and Count({<trade_type_group_cd ='Physical'}>} trade_num)>0 and compliance_checked_flg ='N')

,'Y','N') as FieldName

Note - Please close this thread, If you found what you looking