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

[dathathreya]

Please share the interview questions of qlikview.thanks in advance

[Anil_Babu_Samineni]

Hope this helps.

[dathathreya]

Thanks For Sharing .

[ramasaisaksoft]

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

[dathathreya]

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

[rahulpawarb]

Hello Datha,

Trust that you are doing good!

Please refer attached excel report for your reference.

Hope this will be helpful.

Regards!

Rahul

[Anonymous]

Hi Rama Sai,

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

Thank you.

[ramasaisaksoft]

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"