Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dathathreya
Creator
Creator

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

Please share the interview questions of qlikview.thanks in advance

7 Replies
Anil_Babu_Samineni

Hope this helps.

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
dathathreya
Creator
Creator
Author

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
Creator
Creator
Author

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

rahulpawarb
Specialist III
Specialist III

Hello Datha,

Trust that you are doing good!

Please refer attached excel report for your reference.

Hope this will be helpful.

Regards!

Rahul

Anonymous
Not applicable

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"