topic Re: show message in chart in QlikView

show message in chart

capriconuser — Fri, 06 Dec 2019 11:24:38 GMT

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

Re: show message in chart

Anonymous — Fri, 06 Dec 2019 11:41:30 GMT

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

then define your specific error message

Re: show message in chart

capriconuser — Sun, 08 Dec 2019 05:05:16 GMT

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

Re: show message in chart

Brett_Bleess — Mon, 16 Dec 2019 21:44:22 GMT

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