topic Re: interview question in QlikView

interview question

prabhas277 — Wed, 24 Feb 2016 03:11:10 GMT

Hi Experts,

I have 1 cro records data in table box when I exported to xl how many records will be there and what about remaining records?

How to drop the variables?

I want group the 2 dimension which function u use?

I have2 list boxes and current selection box if click on list box 1 selection should appear in current selection box and when I I click on listbox2 selection should not appear?

Thanks In advance.

Re: interview question

tamilarasu — Wed, 24 Feb 2016 05:13:09 GMT

Hi,

1. Excel 2003 - 65,536 rows ( If you have more than 65536 rows, it will be splitted and stored in next sheets). But you can use CSV file format for large data set. (I have never tried to export 1 crore rows )

2. You can drop variables like below

VariableName = ; or VariableName = null();

3. I don't understand this question. I guess, you are asking about Cyclic Group and Drill-Down Group. You can use this option to group dimensions.

4. You can use HidePrefix syntax in your load script. Search in community for clear example.

Ex: Set HidePrefix = '~';

Hope this helps.

Re: interview question

ramasaisaksoft — Wed, 24 Feb 2016 06:00:06 GMT

Hi Prabhas,

As per MS Office your records will export to excel file.Excel 2003 is having a max limit 65 thousands something like that 2010 and 2013 having some limit and remaining records are not Export to excel may be it fallows First records i am not sure.

2) Drop variables you can drop/Remove variables from

Settings->Variables->select the variable name->click on Remove button.

3) If u want to group 2 dimensions into one dim then u need to use concatenate

LastName &' ' &FirstName as FullName (Here LN & FN are 2 dimensions)

4)I Don't Know this