topic QV script throwing error in QlikView

QV script throwing error

Anonymous — Wed, 25 Apr 2018 19:34:02 GMT

Hi all,

I am a beginner in QV and I am trying to run a particular script , but it is throwing an error.

I am attaching the error message and the complete script for reference.

Can please someone help me determine the error and how to debug the script.

Regards

Mahendra

Re: QV script throwing error

sunny_talwar — Wed, 25 Apr 2018 19:37:09 GMT

Try this

[Aircraft Types]:

Map_Manufacturer_Country:
Mapping

LOAD Company,

Country

FROM [..\Data Files\CSVs\Aircraft_Manufacturers.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

[Aircraft Types]:

LOAD AC_TYPEID as [%Aircraft Type ID],

AC_GROUP as [%Aircraft Group Type],

SSD_NAME as [Aircraft Name],

MANUFACTURER as [Aircraft Manufacturer],

applymap('Map_Manufacturer_Country', MANUFACTURER,'Unknown') as [Aircraft Manufaccturer Country],

LONG_NAME as [Aircraft Name Full],

SHORT_NAME as [Aircraft Name Abbreviated],

BEGIN_DATE as [Aircraft Begin Date],

END_DATE as [Aircraft End Date]

FROM [..\Data Files\CSVs\Aircraft_Base_File.csv]

(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

.... and rest of the script can follow as it is

Re: QV script throwing error

Anonymous — Thu, 26 Apr 2018 18:54:27 GMT

Sunny

Thanks for your prompt response, this really helped.

However I am seeking another guidance from you.

I have a huge number of date values in the format like below:

Jan 1,2017 7:38:08 AM

Jan 2, 2017 7:42:09 AM

Jan 5, 2017 3:01:33 AM

Jan 5 , 2017 3:05:33 AM and so on

This particular date and time format signifies the time of incidents occurred.

My requirement is only to extract the date in the format "1-Jan-2017", "2-Jan-2017","5-Jan-2017" from the above list of values.

Can you please let me know how can I get it done in the QV script itself if possible?

Also if I use a list box I would want the dates to be displayed as unique dates and not duplicates as per the above example.

Regards
Mahendra

Re: QV script throwing error

sunny_talwar — Thu, 26 Apr 2018 19:01:47 GMT

If your timestamp is read as timestamp by QlikView... then all you need is one of these

DayName(DateField)

Date(Floor(DateField))

If it is read as string, then try this

DayName(TimeStamp#(DateField, 'MMM D, YYYY h:mm:ss TT')) as DateField

Date(Floor(TimeStamp#(DateField, 'MMM D, YYYY h:mm:ss TT'))) as DateField

Re: QV script throwing error

Anonymous — Fri, 27 Apr 2018 10:26:46 GMT

Hi sunny

The first two queries worked partially , it gave me the distinct dates in

the format 1/2/2018, 1/15/2018 etc.

I wanted in the format 15-jan-2018.

The last 2 queries did not work.

Regards

Mahendra

Re: QV script throwing error

sunny_talwar — Fri, 27 Apr 2018 11:16:20 GMT

Then use this

Date(Floor(DateField), 'DD-MMM-YYYY')