Mate - Welcome to QV world and Good luck with your new job prospects.
We can help you to answer the questions but the best for you to do is start looking at sample QV documents and take some ideas. I am sure if you look at all the demo applications, you will have clear idea on what you wanted to do.
Also if you need help from the forum... best thing is to post some sample data. This makes it easy for fellow users to demostrate an example with your data.
I had read your requirement and my first thought is that everthing is possible including the optional feature. However, I would strongly recommend you to check the demo application and also look at the QV documentation for syntax & expression help!
Cheers - DV
I'm trying to divide a field called snapshotdate into day, week and month. I used the following syntax:
Day ([SnapshotDate]) as Day,
Week([SnapshotDate]) as Week,
Month ([SnapshotDate]) as Month,
But I'm getting the following error when I try and load the data:
ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: 'Week' is not a recognized built-in function name.
Anyone have an ideas? Thanks
A load from an SQL source consists of two parts - the SQL which is passed to the OLEDB driver, and the QlikView itself. The QlikView comes in the form of a LOAD statement that preceeds the SQL SELECT statement. So something like this:
,Day ([SnapshotDate]) as Day
,Week([SnapshotDate]) as Week
,Month ([SnapshotDate]) as Month
FROM some data source
By default, QlikView will load the fields given in the SQL SELECT, even if you don't explicitly specify the LOAD statement. But I always explicitly specify the load statement.