Re: interview questions - Qlik Community

pavansonu99 · ‎2016-10-06

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.

Anonymous · ‎2016-10-06

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.

Anonymous · ‎2016-10-06

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?

Anonymous · ‎2016-10-06

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 · ‎2016-10-07

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

rajpreeths · ‎2016-10-07

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

Anonymous · ‎2016-10-07

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 · ‎2016-10-07

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 · ‎2016-10-07

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 · ‎2016-10-07

Ww can not get variable in binary load.

-Nagarjun