topic Re: expression help in QlikView

expression help

arusanah — Mon, 11 Jul 2016 17:36:24 GMT

HI there can anybody help me merging these two expressions :

1> =if(count({$<[PGA]={'A'},MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,

-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Recipient Identifier])>count({$<[PGA]={'A'},'arrow up icon','arrow down icon')

2> if(count({$<[PGA]={'A'},MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,

-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Recipient Identifier])=count({$<[PGA]={'A'})>} [Recipient Identifier]),

'resize horizontal icon')

Re: expression help

swuehl — Mon, 11 Jul 2016 17:58:35 GMT

Maybe like

if(

count({$<[PGA]={'A'},MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,

-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Recipient Identifier])=count({$<[PGA]={'A'}>} [Recipient Identifier]),'resize horizontal icon',

if(count({$<[PGA]={'A'},MonthYear={$(='"'&concat(distinct date(Addmonths(MonthYear,

-Getselectedcount(MonthYear)) ,'MMM-YYYY'),'","')&'"')}>} [Recipient Identifier])>count({$<[PGA]={'A'}>} [Recipient Identifier]),'arrow up icon','arrow down icon')

)

Not sure if your syntax of your advanced search is correct, though. Does each expression work on its own?

Re: expression help

arusanah — Mon, 11 Jul 2016 21:47:09 GMT

Thank Sweul!!!

yes my Advanced search was working fine .