Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pavansonu99
Creator
Creator

Re: interview questions

Hi,

ca you please give me Answers for some of my interview questions.

1). If we use binary load will it import section access and variables of loding QVW file.

2) if my QVD is 8 to 9 GB how to compress it.

3) If i have 8 dimensions and 8 expressions in straight table it is loading in 3 min i want load in 20 Sec..    how to do it.

4)  what is the dimension limit option in Pivot table.

10 Replies
vinay_bangari
Specialist III
Specialist III

1). If we use binary load will it import section access and variables of loding QVW file.-- yes it will gets imported in another QVW file

2) if my QVD is 8 to 9 GB how to compress it.--- as far as i know remove unused columns, any key columns present in the QVD convert them into number format,if you have any dimensional data in the QVD for example if both customerID and customerName are present then create a separate QVDs for all dimensional feilds and make sure that data needs to be unique. Mostly this could be a fact table load this data into QVW and using binary load concept and load it into another QVW and build data model from there.

3) If i have 8 dimensions and 8 expressions in straight table it is loading in 3 min i want load in 20 Sec..    how to do it.

--- create a calculated condition or force the chart to be visible when certain feild values are selected.

4)  what is the dimension limit option in Pivot table.--- It can be used to limit the dimension values based on the first expression. for suppose if you wanted to  get top 10 or bottom 10 customers.

viveknair1234
Contributor III
Contributor III

vinay bangari wrote:

1). If we use binary load will it import section access and variables of loding QVW file.-- yes it will gets imported in another QVW file

Hey Vinay,

Could you please tell me if you are sure about the Variable part?

I am unable to see variables created in my child/source QVW  inside the parent/target QVW,am I doing something wrong?

viveknair1234
Contributor III
Contributor III

I guess Variables created using the set statement inside the script would be visible, but any variable created using "Variable Overview" option  will not be accessible.

Anil_Babu_Samineni

Vivek Nair wrote:

vinay bangari wrote:

1). If we use binary load will it import section access and variables of loding QVW file.-- yes it will gets imported in another QVW file

Hey Vinay,

Could you please tell me if you are sure about the Variable part?

I am unable to see variables created in my child/source QVW  inside the parent/target QVW,am I doing something wrong?

For Variable you might write this script, Try this thread

Get list of variable names in macros

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)
rajpreeths
Contributor III
Contributor III

Hi Vivek,

If we do binary load, variables will not get imported from the main QVW .Only data/Data model will get imported in the binary copy.

Refer the attachments for reference please.

Br,

Rajpreeth S

qlikviewnovice
Specialist II
Specialist II

Hi

4. Instead of Dimension limit, you can use " Calculated Dimension "

For example to get Top n values

Re: How to show only Top 10 values in pivot table

Hope it helps!!

rajpreeths
Contributor III
Contributor III

Hello Anil,

No , you are right.

We can not get variables ( whether created in script or UI) imported in the binary copy 🙂

Br,

Rajpreeth S

rajpreeths
Contributor III
Contributor III

Hi Pavan

Pivot table does not have the property of dimensional limit. Its only for available for other charts like straight table , bar charts etc.

Br,

Rajpreeth S

nagarjuna_kotha
Partner
Partner

Ww can not get variable in binary load.

-Nagarjun