Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

capriconuser
New Contributor III

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
Partner
Partner

Re: show message in chart

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

then define your specific error message 

capriconuser
New Contributor III

Re: show message in chart

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 

 

@hrlinder  

Support
Support

Re: show message in chart

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 don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.