Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
manoranjan_d
Specialist
Specialist

NUM

Hi,

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

Amount

7 Replies
Chanty4u
Champion III
Champion III

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

Hi,

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
manoranjan_d
Specialist
Specialist
Author

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

Yes got it then what is issue????

Explain in detail bro

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Kushal_Chawda

try this

LOAD *,

         num(YourDate) as DateNum;

SQL SELECT *

FROM Table;

avinashelite

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
Master III
Master III

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