Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I started on QlikView
I would like in a text box, set a default value if my field here AsOf, is not selected.
How can i do that please ?
Thank you in advance for your help,
Cocalero
If(GetSelectedCount(AsOf) =0, 'Default Text', date(GetFieldSelections(AsOf,','),'MMM-YY'))
Maybe like
=If( GetSelectedCount(AsOf) =0, 'Default Text', ....)
use ur expression >0
=date(getfieldselection(asof,' ,')>0,'mmm-yy')
Try this -
==if(len(GetFieldSelections(OrderDate,','))=0,'MMM-YY',GetFieldSelections(OrderDate,','))
Hello,
Thanks a lot for your advice but it doesn't work, i tried this:
And it returns just '-'.
Thank you in advance,
Cocalero.
If(GetSelectedCount(AsOf) =0, 'Default Text', date(GetFieldSelections(AsOf,','),'MMM-YY'))
if(getfieldselected(Date),1,max(date))
Thanks a lot, it works !