topic Why set expression not giving result ? in QlikView

Why set expression not giving result ?

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

Hello Sirs ,

Below text box expression not giving result

=if(

( aggr(Count(LOG_ID),EMPLOYEE1) )=0, Count(EMPLOYEE1)

)

expected result is 2

Thank You .

Anil_Babu_Samineni — Fri, 09 Nov 2018 10:02:08 GMT

Try this?

Count({<COMPANY1={"=Count(LOG_ID)=0"}>} EMPLOYEE1)

prahlad_infy — Fri, 09 Nov 2018 10:04:18 GMT

any other alternative expression ??

just for my learning

prahlad_infy — Fri, 09 Nov 2018 10:08:31 GMT

please help me understand why

Count({<EMPLOYEE1={"=Count(LOG_ID)=0"}>} EMPLOYEE1) gives 0 , an incorrect

but

Count({<COMPANY1={"=Count(LOG_ID)=0"}>} COMPANY1) gives 2 which is correct

and

Count({<EMPLOYEE1={"=Count(LOG_ID)=0"}>} COMPANY1) give 0 , an incorrect