showing 0000 value in qlik report.

[kishorj1982]

Hi all,

In my database there are 0000 but in qlik report it is showing only 0.

In raw qvd also it can show 0.

Can you please suggest how to show 0000.

Regards,

Kishor

[effinty2112]

Hi Kishor,

                    If Field is your number field try:

=num(Field ,'0000')

Cheers

Andrew

[arvind_patil]

Hi Kishor,

Please convert that field into String and then Check.

Chr([Field Name]) As [New Field]

Thanks ,

Arvind Patil

[kishorj1982]

Hi all,

PFA.

It is not yet working.

IN DB for missing collection manager value is 0000 on report it is showing 0.

Thanks

[Anil_Babu_Samineni]

Please share that data in excel?

[kishorj1982]

I have shared sample app.

Thanks

[Anil_Babu_Samineni]

I know that, Why i am asking is we don't know the real values before load.

Any how, Can you try this?

Num(MissingCollectionManager,'000') as MissingCollectionManager,

OR

Text(MissingCollectionManager) as MissingCollectionManager,

[Kushal_Chawda]

Please share qvd file so that we can try to load it and see what is happening. In this app you have already loaded the QVD.

Num(MissingCollectionManager,'0000') as MissingCollectionManager should work

[arvind_patil]

Hi Kishor,

Please find attachment. It may be solve your purpose

Thanks,

Arvind Patil

[neha_shirsath]

Hi,

Share the excel file not app,so that we can reload application.