Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

show message in chart

when somebody did not work on weekend then i want to show message i.e. 

 

"Abc employee" did not work on weekend .. how i do this 

 

Capture.JPG

3 Replies
Anonymous
Not applicable

you may define a condition for calculation (tab general) like count(employee) <> 0

then define your specific error message 

capriconuser
Creator
Creator
Author

OK i did this 

if(count(Employee_ID) <> 0,'User did not work on weekend')

but nothing happens.. i am selecting owner name from filters .. not Employee ID .. there is employee ID but this chart works when i select name from OwnerName filter 

 

@Anonymous  

Brett_Bleess
Former Employee
Former Employee

You would need to use Set Analysis in order to have things work without making selection:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

That should get you started on things, but someone else may be able to help with the exact expression, but they may need the app in this case in order to see the data model etc.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.