Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I want to know the various techniques we use in script to make the data model perfect in qlikview.
The few techniques i know are, eg- using applymap() to creanup the data model, IF conditions to create new field values, renaming fields etc.
I understand that it depends on the business requirement or may be how we want to build the data model. But I want to have this list, to get an idea about what all I can do to make my data model perfect.
Thanks !!
Regards,
Suraj
Hi Suraj,
As Gerrit said, follow the posts, Blogs in the community regularly and try to answer to the posts. This way you can master in Scripting. Also go through all the topics in Qlikview help file and try to work it out each and every keyword in Qlikview. There are different types of loads, try all of those
Mapping Load
IntervalMatch
Binary Load
Joins
Concatenate
Where & While conditions
Exists
Operators
Hierarchical loads
Generic load
CrossTable
Learn Datawarehouse Concepts
Data Modelling (Star, Snowflake schema)
Qlikview inbuilt functions (Date, String etc)
etc.
This are the alphabets of Qlikview. Try all this with examples and try to understand where to use which, this way you can master in scripting. You can find this topics with examples in Qlikview help file and also n number of posts in community.
Hope this helps you.
Regards,
Jagan.
Hi Suraj,
hard to make a perfect data model... everything can always be impreved!
I would start having a look at http://community.qlik.com/message/188249#188249, and to http://community.qlik.com/servlet/JiveServlet/download/188249-30718/The_QlikView_Data_Model_Best_Pra...
Hope this helps!
Hi,
My advice, start following Blogs and topics in the resource section.
Specially, become friends with Henric Cronström , read everything he published.
Good luck.
Gerrit
Some links:
http://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/
http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join
And, search community for 'optimization', you would get some useful discussions.
Hi Suraj,
As Gerrit said, follow the posts, Blogs in the community regularly and try to answer to the posts. This way you can master in Scripting. Also go through all the topics in Qlikview help file and try to work it out each and every keyword in Qlikview. There are different types of loads, try all of those
Mapping Load
IntervalMatch
Binary Load
Joins
Concatenate
Where & While conditions
Exists
Operators
Hierarchical loads
Generic load
CrossTable
Learn Datawarehouse Concepts
Data Modelling (Star, Snowflake schema)
Qlikview inbuilt functions (Date, String etc)
etc.
This are the alphabets of Qlikview. Try all this with examples and try to understand where to use which, this way you can master in scripting. You can find this topics with examples in Qlikview help file and also n number of posts in community.
Hope this helps you.
Regards,
Jagan.