Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have date field in excel. Now, i want to convert to qlikview date format. Suggest me, Because when i am trying to create one list box with the year it showing 1899 & 2014. But i have only 2014 Data in my excel. Please help me?
My excel date has 3/26/2014 12:00:00 PM
SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;($#,##0.00)';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
2014:
LOAD rep as [2014 rep],
franchise as [2014 franchise],
product as [2014 product],
Date as [2014 Date],
Year(Date) as [2014 Year],
Score as [2014 Score],
groupObservation as [2014 groupObservation],
name as [2014 name],
Username as [2014 Username]
FROM
[2014Data.xls]
All the functions that ends #: time#, date#, money# etc. are interpretation functions. It means that the user defines how to interpret the data.
Nice Chanty
Simple explanation and perfect understanding. Thanks guys.
Anil -
I think that you have not familiarized yourself with the QlikView/Qlik Sense Help yet. What Chanty provided are direct extract from the help sections. I would highly recommend using help to understand things which you don't understand before looking for help here because most of time you will find a good explanation and some examples to go with them on the help page
QlikView Help -> Home ‒ QlikView
Qlik Sense Help -> Home ‒ Qlik Sense
So on the right you see a list of functions you can get help on and I also highlighted Examples and results section which is initially closed, but when you click on it, it will show you some examples here.