topic Re: Need help in the text box in QlikView

Need help in the text box

Tue, 11 Nov 2014 05:31:10 GMT

Hi Friends,

Need help in the Text box object, the expression, as I trying to display if the "COD" has no value it should print "NIL".

But the following expression works but prints as "0", can you help me how to print as Nil if its 0

=If(Len(Trim([COD]=0)),Count({<[COD]={' '}>}[COD]),'Nil')

Regards

Re: Need help in the text box

its_anandrjs — Tue, 11 Nov 2014 05:35:56 GMT

TRy like

=If(Len(Trim([COD])) = 0 ,Count({<[COD]={' '}>}[COD]),'Nil')

Regards

Anand

Re: Need help in the text box

jyothish8807 — Tue, 11 Nov 2014 05:40:27 GMT

Hi Try this:

=If(len(Trim([COD]))>0,count([COD]),'Nil')

Regards

Re: Need help in the text box

Tue, 11 Nov 2014 05:40:44 GMT

Hi,

Thanks for your reply Anand Chouhan, but it still gives same result of 0 only.

Regards

Re: Need help in the text box

its_anandrjs — Tue, 11 Nov 2014 05:45:17 GMT

Try with

=If(Len(Trim([COD])) >= 0 ,Count({<[COD]={' '}>}[COD]),'Nil')

=If(Len(Trim([COD])) > 0 ,Count([COD]),'Nil')

Re: Need help in the text box

PrashantSangle — Tue, 11 Nov 2014 05:47:20 GMT

Hi,

Try

=Count(If(Len(Trim([COD]))=0,[COD]))

Count({<[COD]={"isnull(COD)"}>}[COD])

Regards

Re: Need help in the text box

anbu1984 — Tue, 11 Nov 2014 05:51:09 GMT

Replace ID with primary key from your table

=If(Len(Trim([COD]=0)),Count({<ID={'=Len(Trim([COD]))=0'}>}ID),'Nil')

Re: Need help in the text box

Tue, 11 Nov 2014 07:11:51 GMT

Hi,

Try this,

=if(isnull(COD),'Nil', COD)

Hope it will help.

Apurva

Re: Need help in the text box

mjm — Tue, 11 Nov 2014 12:56:48 GMT

Vincent,

in my view it should simply be,

if(COD='','NIL', COD) as CODValue

Does this help. It simply evaluates if COD is an empty string or not

Please mark this as answered and complete if this is helpful

Re: Need help in the text box

Tue, 11 Nov 2014 13:47:29 GMT

Hi,

If(Len(Trim([COD])) = 0 ,'Nil') Or

Alt([COD], 'Nil')

Re: Need help in the text box

Tue, 11 Nov 2014 13:52:01 GMT

if(isnull(COD)=-1,'nil',0)