Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

Thanks For Sharing .

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

Creator
Creator

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

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

Contributor
Contributor

Hi Rama Sai,

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

Thank you.

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"