topic Re: can any one plz share the interview questions on senario basis. in QlikView

can any one plz share the interview questions on senario basis.

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

Please share the interview questions of qlikview.thanks in advance

Re: can any one plz share the interview questions on senario basis.

Anil_Babu_Samineni — Tue, 11 Apr 2017 05:52:40 GMT

Hope this helps.

Re: can any one plz share the interview questions on senario basis.

dathathreya — Tue, 11 Apr 2017 06:10:54 GMT

Thanks For Sharing .

Re: can any one plz share the interview questions on senario basis.

ramasaisaksoft — Tue, 11 Apr 2017 06:27:23 GMT

Hi Datha,

Scenario 1)

if i got an error in Drop table issue while script execution/Reload what are the different solutions you know?

1)First i need to verify if the table is exist or not?

2)If table is there then verify the spelling

3)IMP:- May be this table is Auto concatenated with other table/i e before loading tables which are already have same columns.

Scenario 2:-

2 tables i have in script Tab1 ,Tab 2

and 4 Columns are there in 2 tables

with 5 and 10 records simultaneously

if there are 2 matched rows in both tables then what will happen in the output/Data model

Questions are like

1)if i use Join, how many Tables & records will come in Data Model?

2)if i use Keep ,how many Tables & records will come in Data Model?

3)if i use Apply Map ,how many Tables & records will come in Data Model?

4)if i use Forced Concatenate, how many Tables & records will come in Data Model?

Scenario 3:-

Think about there is a ST table how you will give different colors as per the sales (i mean sales column/Expression data need to show different colors like if sales is >5000 Red color ,Sales >10000 green else Black color..etc)

Scenario 4-

what are the different Dimension Tables and Fact tables for a University?

explain some Now and why you choose those are dims and Facts convey him

..etc

Re: can any one plz share the interview questions on senario basis.

dathathreya — Tue, 11 Apr 2017 06:33:07 GMT

Thanq Rama Sai.Can u please provide answers to scenario 2 and 4.

Re: can any one plz share the interview questions on senario basis.

rahulpawarb — Fri, 14 Apr 2017 04:34:17 GMT

Hello Datha,

Trust that you are doing good!

Please refer attached excel report for your reference.

Hope this will be helpful.

Regards!

Rahul

Re: can any one plz share the interview questions on senario basis.

Anonymous — Wed, 01 Nov 2017 14:14:29 GMT

Hi Rama Sai,

Your small example sheet gave good clarity about applymap ,join and keep.

Thank you.

Re: can any one plz share the interview questions on senario basis.

ramasaisaksoft — Thu, 02 Nov 2017 05:16:44 GMT

if possible please share the .qvw which you practiced .for the above scenarios so that others will also got idea

1)if i use Join, how many Tables & records will come in Data Model?

count of input records and count of output records?

2)if i use Keep ,how many Tables & records will come in Data Model?

count of input records and count of output records?

3)if i use Apply Map ,how many Tables & records will come in Data Model?

count of input records and count of output records?

4)if i use Forced Concatenate, how many Tables & records will come in Data Model?

count of input records and count of output records?

if you got solution for your query please close the thread by "Marked as useful"