Hi everyone,
Is it possible to hide related columns when their result is zero or null?
In the bellow picture there are several related columns only the "Contactos# one has a result. How can I hide the ones that have no result?
thanx a million
Solved! Go to Solution.
Hi Marc,
thank you for your reply!
Which one of the options you believe is the best practice?
Use COUNT() in the show_if expression. It was intended as only 1 option.
Thanks again!
I suck with expressions that’s why I have so much trouble with these issues…
I will study the link you sent me
thanks again mate
Hi Marc,
I’ve been trying to set the count up with no success, I don’t understand the way Count will count the rows of column a related to a table, in this case a slice…
Can you r someone help?
Hi @Luis_Gomes_Machado
Maybe try something like this in SHOWIF
COUNT([Related Column]) >= 1
What did you try?
In addition to what @Lynn said, can you try that: ISNOTBLANK([Related Column])
(It’s an equivalent solution in my opinion)
I just gave it a try for testing, that works on my app.
Make sure you set this expression here:
@Aurelien
Nice!
Thank you so much you all for helping me
Still I am doing something wrong…
does it have to do with the column structure of my slice?
??
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |