How to show no result when selection is invalid in embedded sheet
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".
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.
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.
