topic Re: interview questions in QlikView

Re: interview questions

pavansonu99 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: interview questions

Anonymous — Thu, 06 Oct 2016 20:00:35 GMT

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.

Re: interview questions

Anonymous — Thu, 06 Oct 2016 20:29:52 GMT

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?

Re: interview questions

Anonymous — Thu, 06 Oct 2016 20:34:41 GMT

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

Anil_Babu_Samineni — Fri, 07 Oct 2016 07:42:17 GMT

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

Re: interview questions

rajpreeths — Fri, 07 Oct 2016 09:59:50 GMT

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

Re: interview questions

Anonymous — Fri, 07 Oct 2016 10:00:00 GMT

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!!

Re: interview questions

rajpreeths — Fri, 07 Oct 2016 10:01:41 GMT

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

Re: interview questions

rajpreeths — Fri, 07 Oct 2016 10:09:05 GMT

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

Re: interview questions

nagarjuna_kotha — Fri, 07 Oct 2016 11:06:45 GMT

Ww can not get variable in binary load.

-Nagarjun

Re: interview questions

Anonymous — Fri, 07 Oct 2016 16:42:48 GMT

Hi pavan,

1) section access applicable on binary load, but it doen't carry any variables along with it.

2)qvd is 8 gb means source data in more than 80gb, inthat case 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.

source:@vinay Bangari

3)Pivot table is special to group dimensions, there is no fixed option for that.

hope u get answered well .

Regards

Pavan