topic Re: NUM in QlikView

NUM

manoranjan_d — Fri, 13 May 2016 05:28:29 GMT

Hi,

I want the below field has to be in num format, so can i declare

Amount

Chanty4u — Fri, 13 May 2016 05:30:48 GMT

please explain more? which object u need to decalre?

If charts goto number tab and make it to Number.

if not share some sample

PrashantSangle — Fri, 13 May 2016 05:33:48 GMT

Hi,

there is num() and num#() available for you.

Regards

manoranjan_d — Fri, 13 May 2016 05:34:46 GMT

before retrieving the date in the qvd generator i have to retrieve the same date field in num format to make simplification

example:

load

num(createddate) as createddate_num,

date(createddate,'MMDDYYYY') as createddate,

from table.

PrashantSangle — Fri, 13 May 2016 05:41:19 GMT

Yes got it then what is issue????

Explain in detail bro

Regards,

Kushal_Chawda — Fri, 13 May 2016 05:43:29 GMT

try this

LOAD *,

num(YourDate) as DateNum;

SQL SELECT *

FROM Table;

avinashelite — Fri, 13 May 2016 05:43:54 GMT

if you want to convert string to number than try with num#(field_name)

if you want to format the number than try with num(field_name)

share the sample data that will be helpful for us to suggest the solution

sujeetsingh — Fri, 13 May 2016 06:22:56 GMT

seems manoranjan just posted this for some entertainment as his name depicts.