topic Re: Expression in QlikView

Expression

smilingjohn — Fri, 29 Apr 2022 17:33:23 GMT

Hi All,

I am trying to get the data based on row to row match comparing to fields , but along with set analysis

the expression don show any error but this even doesn't give any out put also , Can any one please help me in correcting my expression

=if(Product=SubProd,
count(Distinct{<STATUS_NAME-={'Delivered'},
SEVERITY={'1 - Critical','2 - High','3 - Medium' }>} if(CREATE_DATE>IntDate , ID)))

Thanks

Re: Expression

MarcoWedel — Sat, 30 Apr 2022 10:53:46 GMT

can you please post some sample values and your expected result as well?

thanks

Re: Expression

Vegar — Sat, 30 Apr 2022 21:27:32 GMT

Your issue can be casued by many things, it's hard to pinpoint whitout more details.

However, my first thing to check would be the result of Product=SubProd. If you have more than one Product and SubProduct per calculation you will run into issues.

It this is the issue then you might be able to do a workaround using this expression.

=count(Distinct{<STATUS_NAME-={'Delivered'}, SEVERITY={'1 - Critical','2 - High','3 - Medium' }>} if((CREATE_DATE>IntDate) AND (Product=SubProd) , ID))

Re: Expression

smilingjohn — Sun, 01 May 2022 00:30:56 GMT

Thanks a lot Vegar you rock man ✌️