Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Kishor,
If Field is your number field try:
=num(Field ,'0000')
Cheers
Andrew
Hi Kishor,
Please convert that field into String and then Check.
Chr([Field Name]) As [New Field]
Thanks ,
Arvind Patil
Hi all,
PFA.
It is not yet working.
IN DB for missing collection manager value is 0000 on report it is showing 0.
Thanks
Please share that data in excel?
I have shared sample app.
Thanks
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,
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
Hi Kishor,
Please find attachment. It may be solve your purpose
Thanks,
Arvind Patil
Hi,
Share the excel file not app,so that we can reload application.