Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
can any one explain the following questions
1)Qlikview project end to end implementation?
2)what is 2 tier and 3 tier architecutre?
3)How to handle null's in qlikview?
4)The dashboards and reports created how it can be delivered to the end user?we have qlikpublisher to deliver it to qlikserver so that end users might be viewing it?can any one explain the details of it?
5)What is binary load in qlikview?
6)what is the difference between star schema and snowflake schema?When to go for which schema and why?
7)Qlik uses the associations when so where primary and foreign keys are used?
8)How to delete duplicate records from the tables?
9)Qlikview dashboard is created and later got the requirement to add some additional fields to the dashboard,then how can we perform this task?we can add the new fields in the script or we can add new fields in the source database layer and load the script?
10)What are the best data modelling techniques?what is subset ratio in qlikview?
11)time it takes to load data into qlikview example 1000000 records?Explain
12)What are the steps to connect to Sap bw system from qlikview?
13)How can we optimize the qlikview dashboard?
14)What is condition enabling in qlikview?
15) What adhoc reports in qlikview?how to create adhoc reports in qlikview?
16)what is difference between drill down and cyclic group?
17)what is the use of apply map in qlikview?
18)what are the types of incremental loads?
19)what is the use of the section access?how to create section access?where do we use it in application level or database level?
20)In 5gb file how many records can be accomodated?
21)set analysis what is the expression for displaying the last 6 months sales date?
22)How can we reduce the load time of qlikview applications?
23)what are the important functions that are used in qlikview?
24)what is alternate state in qlikview?explain with an example?
25)what is pivot table?when we can use pivot table?
26)Debugging qlikview dashboard?
27)
I have attached sample sales superstore excel file for example we are creating sales dashboard.it contains three tables orders,returns,users?l
can any one explain the process from connecting to the source excel file to creating the dashboard?
tables loaded from the database by connecting to database or excel file,then what are the steps to be taken?
for example:
Data Source preparation
Designing the data model
how to choose which data model in the context of the excel file attached?
Designing the UI
Unit Testing
UAT / SIT
Deployment
Production Support
by connect to the source excel file
extract the data
create qvd
design the dashboard with script.
while reloading the script synthetic keys and circular references can be avoided by creating composite keys,renaming the fields etc.
resident load
binary load
inline load
incremental load
add load
buffer load
joins:inner joins
left outer join
right join
outer join
What is the step by step procedure explain with script?
If you really want to learn Qlik than I suggest starting here:
QlikView Developers (June 2017)
Barry Harmsen und Miguel Garcia
ISBN-13: 978-1786469847
- Marcus
Hi,
Thanks for the repky. But I'm following the same Barry Harmsen und Miguel Garcia.
for learning the advanced level of QlikView any books can you suggest
Thanks
Vijay
Following people here in the community or in their personal blogs or other social media sites is definitely useful but it couldn't replace a continuous study with a courses or books. If you are really comfortable with the above suggested basics you could go further here:
Mastering QlikView (November 2014)
Stephen Redmond
ISBN-13: 978-1782173298
Mastering Qlikview Data Visualization (April 2016)
Karl Pover
ISBN: 978-1782173250
- Marcus