Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Data Extract from QVW file

Hello,

I currently working on a dashboard and I am extracting data from an existing file.

I successfully extracted the data but I need to manipulate the field (to produce date fields like Month, Year)

I need tips on how to do this

Please see attachments for clarity..

Best Regards

Akpofure

1 Solution

Accepted Solutions
sunny_talwar

Can you check and see if this is what you want?

Capture.PNG

View solution in original post

22 Replies
sunny_talwar

I guess create a Master Calendar which links to your field you want it to link to.

maheshkuttappa
Creator II
Creator II

Calender

Load

<Date.Filed Name> As date

Month(<Date.Filed Name>) as Month

MonthName<Date.Filed Name> ) as MonthName

Year(<Date.Filed Name> ) as Year.

resident <tableName

Anonymous
Not applicable

You could add a new Mater Calendar table Creating A Master Calendar‌in your and join that to the date field from your binary load.

maheshkuttappa
Creator II
Creator II

Calender

Load

Date.Filed Name

<Date.Filed Name> As date

Month(<Date.Filed Name>) as Month

MonthName<Date.Filed Name> ) as MonthName

Year(<Date.Filed Name> ) as Year.

resident <tableName>

akpofureenughwu
Creator III
Creator III
Author

Thanks Sunny for your quick response and good suggestions.

Can you help me with tips on how to achieve that..

I tried introducing scripts after the binary statement.

It doesn't response...

sunny_talwar

Can you share the script you have tried?

akpofureenughwu
Creator III
Creator III
Author

Thanks M. Kumar

Please I try this script you suggest, It didn;t load..

Please find attached file....

Maybe I didn't arrange the syntax well...

The table name is the one I will give to the qvw file.

akpofureenughwu
Creator III
Creator III
Author

Please find attachment

maheshkuttappa
Creator II
Creator II

Few things are not right

Remove  "Calender: " Before Binary  load ( Please read the concept of binary load and its limitation)

Then below script

Load

CH.DOC.LAST_CHANGED_AT

CH.DOC.LAST_CHANGED_AT As date,

Month(CH.DOC.LAST_CHANGED_AT) as Month,

MonthName(CH.DOC.LAST_CHANGED_AT) as MonthName,

Year(CH.DOC.LAST_CHANGED_AT) as Year,

resident "Name of the table in which field CH.DOC.LAST_CHANGED_AT is present after binary load "

As Sunny and Bill suggested  Master calendar is way to go..