CONTEXT("View") = "Pendency" || 'No items" Error

[Sirfyaad]

I want to show custom message instead of "no items". But the show is not happening here. 

IF(
CONTEXT("View") = "Pendency", "Great 👍",
IF(
CONTEXT("View") = "Same-day Report", "Awaiting for Scanning",
IF(
CONTEXT("View") = "bad stock", "Today No Scan Data Found",
"No Items"
)
)
)

[mattlops]

The expression looks okay to me, have you tried to use SWITCH() to see if resolves ?

SWITCH(
CONTEXT("View"),
"Pendency", "Great",
"Same-day Report", "Awaiting for Scanning",
"bad stock", "Today No Scan Data Found",
"No Items")

Sometimes when I use IF(IF()) or IFS() the AppSheet doesn't show any error in the formula, but it doesn't usually work correctly either

https://support.google.com/appsheet/answer/10107700?hl=en

[Sirfyaad]

Thank you so much for your Response @Tommy62 @mattlops .

Here expression are not doing proper work. Always show No items

I want that if "Pendency" has no data then show "Great" and when "Same-day Report" has no data then show "Waiting for Scanning"

[mattlops · Accepted solution]

Have you solved this?
I think it's a "bug". I try to put two different values to translate text in my apps, and the same issue occurs. Maybe it's not possible yet?

[Sirfyaad]

Working here but there is a problem. In the dashboard slices only No items are visible. And when I make the slice view full, it looks correct. 

[Tommy62]

Vielleicht hilft dieses kurze Video weiter: How to Create a Pop Up Help Info