topic Re: How to show no result when selection is invalid in embedded sheet in App Development

How to show no result when selection is invalid in embedded sheet

OTwist — Fri, 25 Feb 2022 10:08:25 GMT

Hello, I am a new developper in QlikSense.

This is my first post, I hope I am not out of line, but please, if so, do let me know 🙂

So, I am developping a dashboard on QlikSense to be displayed as an embedded item in Salesforce. The goal is to show the sales of a customer. For this purpose, we pass the customer number as a selection to the Dashboard. From time to time, the customer exists in Salesforce but has no data in my dashboard. Which is completely normal.

However, in this case, the dashboard display the whole sales instead of none as there is "no selection".

Can this be avoided ? any tips welcome !

Re: How to show no result when selection is invalid in embedded sheet

Digvijay_Singh — Sat, 26 Feb 2022 04:09:51 GMT

I may have misunderstood, but looks like you only want to show measure value if there is a selection in the customer number, probably you would try to add a check in your measure -

if (getselectecount(Customer_Number) >0, Sum(Sales), 'No Selecttions')

Not sure if that would work as intended but you may try something like this.

Re: How to show no result when selection is invalid in embedded sheet

OTwist — Wed, 02 Mar 2022 22:11:48 GMT

Thanks, that did help indeed !