Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Hope this helps.

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)
Highlighted
Creator
Creator

Thanks For Sharing .

Highlighted

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

Highlighted
Creator
Creator

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

Highlighted
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

Highlighted
Contributor
Contributor

Hi Rama Sai,

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

Thank you.

Highlighted

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"