topic Re: Need Ans for the foll. Interview Questions faced during Project Interview. in QlikView

Need Ans for the foll. Interview Questions faced during Project Interview.

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have 1.6+ years of Exp in QV 11.2. I'm, giving interviews for the Internal projects. Below are the few questions that I faced during Interview and need to have their answers. Kindly help please.

1. Non-Optimized Load and Duration time

Situation 1: Plain Extraction and Apply Map

Situation 2: Resident Load on Extracted QVD and then Apply Map

Situation 3: Preceding Load and Apply Map

From above 3 situations, rank in order on the basis of fastest, faster, fast load and why?

2. Straight Table has a few Ds and Es that shows Currency as $USD. With the list box provided that has option it to change to Pound and INR then how the selection must change the values in Straight Table to the selected Currency?

3. Dashboard is in English and now if the list box is provided that has values Spanish, Japanese and etc then how the complete dashboard will change its language?

4. How to color the alternate rows of the Straight Table having 5 Ds and 3 Es?

5. Initial Data reduction based on Section Access is checked and Strict exclusion is unchecked, what will happen?

6. Is it mandatory to write the Section Access code in Hidden script? If so, why?

7. What is "Section Application" in the section access code?

8. Have 1 QVD that has data for Q3-2017 and Q4-2017. Now, I have to append the data for Q1-2018 and remove Q3-2017 data in the same QVD using Incremental Load.

Also, do let me know where can I get such scenario based questions to study?

Thank you so much in advance. Eagerly waiting for the answers to pen down.

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

Peter_Cammaert — Tue, 06 Mar 2018 11:57:16 GMT

Isn't that ... cheating?

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

shiveshsingh — Tue, 06 Mar 2018 12:26:53 GMT

1. Non-Optimized Load and Duration time

Situation 1: Plain Extraction and Apply Map

Situation 2: Resident Load on Extracted QVD and then Apply Map

Situation 3: Preceding Load and Apply Map

From above 3 situations, rank in order on the basis of fastest, faster, fast load and why?

Situation 3, Situation2, situation 1 in order of decreasing ( fast)

preceding load will take only one turn to load the data

Resident will first load the original data and then resident load

extraction from source is slow in compare to these loads

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

shiveshsingh — Tue, 06 Mar 2018 12:32:17 GMT

Straight Table has a few Ds and Es that shows Currency as $USD. With the list box provided that has option it to change to Pound and INR then how the selection must change the values in Straight Table to the selected Currency?

For this, you need to format your expression output so tat it starts giving desired value

num(Expression_output,vFormat)

Now define the vFormat like below.

=if([List Box Value]='X','$#,##0','#,##0')

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

shiveshsingh — Tue, 06 Mar 2018 12:33:17 GMT

3. Dashboard is in English and now if the list box is provided that has values Spanish, Japanese and etc then how the complete dashboard will change its language?

You need to create language Variables for this.(translation files will be required)

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

shiveshsingh — Tue, 06 Mar 2018 12:35:16 GMT

Have 1 QVD that has data for Q3-2017 and Q4-2017. Now, I have to append the data for Q1-2018 and remove Q3-2017 data in the same QVD using Incremental Load.

This can be done through Where exists function, i guess

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

shiveshsingh — Tue, 06 Mar 2018 12:36:14 GMT

5. Initial Data reduction based on Section Access is checked and Strict exclusion is unchecked, what will happen?

6. Is it mandatory to write the Section Access code in Hidden script? If so, why?

7. What is "Section Application" in the section access code?

You can easily get answers of these questions in the community itself, please do some research

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

shiveshsingh — Tue, 06 Mar 2018 13:02:20 GMT

4. How to color the alternate rows of the Straight Table having 5 Ds and 3 Es?

=if(Even(RowNo(TOTAL)), Put colour)

This will put color in alternate row.

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

Anonymous — Wed, 07 Mar 2018 05:58:41 GMT

Hi Peter,

Apology if u feel so but these were the questions I already faced just needed to tally it with my ans if I was correct or not as the Interviewer didn't said neither correct nor wrong. Thanks.

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

Anonymous — Wed, 07 Mar 2018 06:05:08 GMT

Thanks Shivesh for solving almost all questions.

1. But if I'm not wrong Resident load takes more time than plain extraction because u load ur 1st QVD, apply transformation using resident load (means same QVD loading twice + Applymap) please correct me if I'm wrong.

My ans was : 1. Preceding (fastest) 2. Plain Extraction (faster) 3. Resident

2. For the Quarter data using Incremental load.. We need to use all the 3 concepts right: Insert, Update, Delete?

3. Language variable means: can u put some light on this to change the language.

4. For the Currency conversion, its not just the sign we need to think we need the Rs. to be converted into Pounds or USD or vice versa.

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

imrasyed — Wed, 07 Mar 2018 06:21:06 GMT

6. Is it mandatory to write the Section Access code in Hidden script? If so, why?

Please go through the below link.Very informative

QlikView Section Access Examples

Introduction to Section Access

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

shiveshsingh — Wed, 07 Mar 2018 10:18:51 GMT

Section Access: Strict Exclusion

Re: Need Ans for the foll. Interview Questions faced during Project Interview.

shiveshsingh — Thu, 08 Mar 2018 17:02:49 GMT

My ans was : 1. Preceding (fastest) 2. Plain Extraction (faster) 3. Resident

I think, resident load will be faster

2. For the Quarter data using Incremental load.. We need to use all the 3 concepts right: Insert, Update, Delete?

It depends on your data, if new data is having duplicate data , use update or if some records are deleted then use Delete option further

3. Language variable means: can u put some light on this to change the language.

You need translation files for this, and then create language variable wherever you want to dynamically change the text

4. For the Currency conversion, its not just the sign we need to think we need the Rs. to be converted into Pounds or USD or vice versa.

Yes, you need to convert it as per latest rates,