Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

pavansonu99
Contributor

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
Valued Contributor III

Re: interview questions

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
New Contributor III

Re: interview questions

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
New Contributor III

Re: interview questions

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.

Re: interview questions

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
New Contributor III

Re: interview questions

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
Valued Contributor II

Re: interview questions

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
New Contributor III

Re: interview questions

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
New Contributor III

Re: interview questions

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

Partner
Partner

Re: interview questions

Ww can not get variable in binary load.

-Nagarjun