topic Re: Default Value in TextBox in QlikView

Default Value in TextBox

Anonymous — Mon, 21 Mar 2016 16:27:18 GMT

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

swuehl — Mon, 21 Mar 2016 17:42:26 GMT

Maybe like

=If( GetSelectedCount(AsOf) =0, 'Default Text', ....)

Chanty4u — Mon, 21 Mar 2016 17:43:52 GMT

use ur expression >0

=date(getfieldselection(asof,' ,')>0,'mmm-yy')

Digvijay_Singh — Tue, 22 Mar 2016 04:31:09 GMT

Try this -

==if(len(GetFieldSelections(OrderDate,','))=0,'MMM-YY',GetFieldSelections(OrderDate,','))

Anonymous — Tue, 22 Mar 2016 09:10:54 GMT

Hello,

Thanks a lot for your advice but it doesn't work, i tried this:

And it returns just '-'.

Thank you in advance,

Cocalero.

Kushal_Chawda — Tue, 22 Mar 2016 09:16:26 GMT

If(GetSelectedCount(AsOf) =0, 'Default Text', date(GetFieldSelections(AsOf,','),'MMM-YY'))

Anonymous — Tue, 22 Mar 2016 09:21:23 GMT

if(getfieldselected(Date),1,max(date))

Anonymous — Tue, 22 Mar 2016 09:22:33 GMT

Thanks a lot, it works !