Discussion Board for collaboration related to Creating Analytics for QlikView.
I need an expression for conditional show to hide a text box when no selection is taken.
Go to Solution.
Thanks to you Gents I was able to solve it.
if(GetSelectedCount([AnyObjectOnSheet])=1 and not IsNull([Extended Till]),1,0)
Try this expression it works.
IF(Count(distinct [Customerid]) >1, 0,1)
First Right Click on Text object ==> Layout tab ==> Conditional = NOT ISNULL(GetFieldSelections(YourField))
Hope this help.
Thanks for your tip.
what I am trying to do is to get [Extended Till] Date if there was an extension from my data, and it works perfectly with the following formula
now what I want to add is that if I clear all selections from my entire sheet, I want this box to disapear
Did you try expression NOT ISNULL(GetFieldSelections([Extended Till])) yet? This work for me when I clear selected values.
Thanks for your reply I tried it but didn’t work!! The box totally disappears and even when I do have an extension (TRUE VALUE)
maybe cuz my sheet is a bit complicated ☹
Can you share your app? It may easy to find solution.
Well done Wael.