Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
prahlad_infy
Partner - Creator II
Partner - Creator II

Why set expression not giving result ?

Hello Sirs ,

Below text box expression not giving result

=if(

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

)

expected result is 2

Thank You .

PK

1 Solution

Accepted Solutions
Anil_Babu_Samineni

Try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

3 Replies
Anil_Babu_Samineni

Try this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
prahlad_infy
Partner - Creator II
Partner - Creator II
Author

any other alternative expression ??

just for my learning

prahlad_infy
Partner - Creator II
Partner - Creator II
Author

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