topic Interview Questions for one year experience in QlikView

Interview Questions for one year experience

Tue, 22 Mar 2011 08:37:57 GMT

Hi,

Imagine you as a interviwer. if you interview a person with one year experience. what are all the techinical question you are asking.

Interview Questions for one year experience

matt_crowther — Tue, 22 Mar 2011 08:51:46 GMT

Try these:

Query	What to look for...

How would you describe a: a) Dashboard b) MI solution	Basic BI / MI knowledge

What is it that drew you to working with QlikView	Response around solutions that can be delivered / end user satisfaction - rather than a feature list

Describe some of the solutions you have built in QlikView	Applicacations around finance / insurance

What parts of QlikView project life cycles have you been involved in	Comfortable in dealing with people as well as software

What feature of QlikView would you like best, and why	This one is subjective - but may draw an interesting response

What would you say the limitations / flaws with QlikView are	Again very subjective

What presentation object would best suit......	Holds an opinion on basic data presentataion

What is a QVD file and why might you use one	It's a data repository file, can aid a robust / quick reload strategy, essential for incremental loads of data

What is the difference between optimized and non optimized QVD load	When retreiving from QVD optimized mode is up to 100x quicker - only works if you follow a set of rules

Describe the use of the ApplyMap statement	Used for mapping data from one source onto another at load time, very flexible in how it does this

How might you seek to decrease memory usage by a document	Drop redundant items, remove granularity (eg. drop time from datetime fields), split fields (eg. post codes)

What kind of optimisations can be done to data models	Merge tables to reduce joins at run time - create a flatter structure at load time

Describe the crosstab directive; how and why would you use it	Transforms columns into rows by dimensions (eg. in Excel where have cols for description then one col per month)

What is a calculation condition and why would you use one	Stops a potentially costly calculation / display taking place by checking a more efficient expression first

What is a show condition and how does it differ from calculation condition	Similar to calculation condition but the object is removed from the screen rather than displaying a message

What are the advantages of using a theme	Contains all UI attributes in a single file, when new objects are created they can pick up from the theme

Why might you make use of variables	Can keep re-useable code snippets, calculate values for global use, maintaining state of objects

Also additional attached.

Of course the subject matter could be very wide and depends on whether your role is more toward dashboard development / scripting, small scale or large scale etc etc.

Hope that helps,

Matt - Visual Analytics Ltd

Interview Questions for one year experience

Tue, 22 Mar 2011 08:52:37 GMT

1. What is the difference between Set and Let?

2. How many dimensions can be used in Bar chart?

3.Which Qlikview object has only expression, no dimension?

4.What is the difference between Concatenate Load and Join?

5. Incremental Load

6. Synthetic keys . How to remove them

7. What is Circular reference? How to avoid them?

8. Have you used any macros in your application? If so, what you have used it for.

9. What is Set Analysis ( benefits of using it)? Why its called Set Analysis

10. Difference between Qlikview version 9 SR 6 and previous other Qlikview 9 versions?

11. What is the use of exists function in qlikview?

Interview Questions for one year experience

suniljain — Tue, 22 Mar 2011 09:00:07 GMT

1) What is BI ?.

2) Qlikview vs SAP BO or Cognos .

3) What do you mean by In Memory BI tool ?. Advantage and Disadvantage.

4) ETL in Qlikview ?.

5) Security in Qlikview

6) QEMC and QMC

7) DMS and NTFS

😎 Set Analysis

9)Features in QV 8.5 , QV 9 , QV 10

10) Challenges you faced during Implementation

Interview Questions for one year experience

Tue, 22 Mar 2011 09:06:33 GMT

Normal 0 false false false EN-IN X-NONE X-NONE

1. Difference between AJAX and IE-Plug-in

2. IIS is able to use in QlikView 9 server

3. Difference between LET and SET

4. Difference between straight table and pivot table

5. Difference between grid chart and scatter chart

6. How to implement Dynamic Google map

Interview Questions for one year experience

Tue, 22 Mar 2011 09:07:57 GMT

Thanks Sunil

Interview Questions for one year experience

Tue, 22 Mar 2011 13:02:51 GMT

Nice One !!

Interview Questions for one year experience

Wed, 13 Apr 2011 08:06:37 GMT

can u also please provide asnwers to ur questions.

thanks

Interview Questions for one year experience

Wed, 13 Apr 2011 08:07:12 GMT

please also provide asnwers

thanks

Interview Questions for one year experience

Mon, 24 Oct 2011 11:23:32 GMT

Adding to the list of questions

1. What is the use of QEMC?

2. Have you worked on publisher? What is the use of it?

Thanks

Attitude

Interview Questions for one year experience

suniljain — Tue, 25 Oct 2011 06:19:54 GMT

if you really worked in qlikview for one year. then there is no question for whon you do not have answer.

Interview Questions for one year experience

suniljain — Tue, 25 Oct 2011 06:41:30 GMT

Qlikview reference manual is too enough.

Interview Questions for one year experience

Tue, 25 Oct 2011 07:01:37 GMT

Hi Sunil

Thanks for your comments! I didn't say anywhere that I need answer for the questions. I just added the questions which have been asked for and it will be helpful for someone.

May I know what makes you to ask like that?

Thanks

Attitude

Re: Interview Questions for one year experience

suniljain — Tue, 25 Oct 2011 07:11:48 GMT

donot take it negatively. I want to say that Qlikview refrence manual cover all the concept.

Even I also posted some question. so its not an issue.

Interview Questions for one year experience

Tue, 25 Oct 2011 07:14:04 GMT

Hi Sunil

When you said like that I felt bad for that. Thats why I asked what made you to ask like that.

"if you really worked in qlikview for one year. then there is no question for whon you do not have answer."

Thanks

Attitude

Interview Questions for one year experience

suniljain — Tue, 25 Oct 2011 07:17:34 GMT

I mean to say that is

if anyone worked in qlikview then there is no need to refer any seperate document for iterview. all the things normally covered during working on project.

Happy Diwali !!!!!

Interview Questions for one year experience

Tue, 25 Oct 2011 07:35:22 GMT

Hi Sunil

Yes! You are correct but there are some cases where we may not be to able to answer when the interviewer asks during the interview. So better to be prepared with some sets of questions for getting through the interview.

Thanks

Attitude

Interview Questions for one year experience

suniljain — Tue, 25 Oct 2011 10:23:13 GMT

its also true.

Interview Questions for one year experience

Thu, 12 Jan 2012 09:51:17 GMT

Hi All

May I know how many dimensions can be used in Bar chart?

Regards,

Attitude

Interview Questions for one year experience

Wed, 08 Feb 2012 05:59:55 GMT

Hi At titude,

U can have upto 3 dimensions in a bar chart.

Thanks,

Rathish