topic interview question in QlikView

interview question

Mon, 13 Jul 2015 04:12:39 GMT

hello can i get answers for this question plz

How to get current selection in the Drill down /cyclic group field?

How to optimize qlikview Application?

what is valuelist and valueloop functions?

Re: interview question

jagan — Mon, 13 Jul 2015 04:33:50 GMT

Hi,

- GetCurrentField() - will return the current field in the Group.

- ValueList and ValueLoop() - They are used for creating synthetic dimensions on the fly, Refer Qlivkiew help file for syntax and example

Re: WHat is ValueList() and ValueLoop() ?? How they are used ??

Optimize Qlikview application:

The major areas in Optimizing Dashboard is

Good Data Model

Sufficient RAM

Expressions (Try to avoid Aggr, Calculated Dimensions, etc)

Limited Calculations in Expressions

Don't display huge data in Straight, Pivot and Table boxes (Restrict user to select filters to reduce data to be displayed in table)

Qlikview file size (Load only dimensions and data which are used in Dashboard)

etc.

Check below link

Re: major areas in optimizing Qlikview application

Re: what are the guide lines you follow to develop a qlikview application?

Re: interview question

ramasaisaksoft — Mon, 13 Jul 2015 04:36:26 GMT

Hi Naveen,

How to get current selection in the Drill down /cyclic group field?

GetCurrntField(GroupName)

Ways to get current selection in the Drill down /Cyclic group field?

How to optimize qlikview Application?

Optimising Qlikview means increase the speed of the application for any selection did by client in access point and also increase the speed of the application reloading for scheduled time i.e decrease the time of loading.

1)you need to remove unnecessary columns from Edit script(delete unnecessary columns,drop unnecessary tables)

2) Reduce joins to less number

3)Remove synthetic keys,Tables and also remove circular loops

4)Load data using qvd's

5)if possible reduce the set analysis expressions in front end and do it those in script level.

...etc

what is valuelist and valueloop functions?

1.synthetic dimension functions (valuelist &value loop).

2. dimension wise it 'll display tthe values.

For Example:

syn: valuelist('1','5') it'll display the only 1&5 values

valueloo('1','5') it'll display the all( 1,2,3,4,5 values)

WHat is ValueList() and ValueLoop() ?? How they are used ??

Re: interview question

mohammadkhatimi — Mon, 13 Jul 2015 04:37:54 GMT

PFA...optimize qlikview Application

Re: interview question

mohammadkhatimi — Mon, 13 Jul 2015 04:41:42 GMT

PFA...valuelist and valueloop functions

Re: interview question

mohammadkhatimi — Mon, 13 Jul 2015 04:43:37 GMT

How to get current selection in the Drill down /cyclic group field?

You can use the function GetCurrentField as:

GetCurrentField(GroupName)

Returns the name of the currently active field in a group.

Regards,

Mohammad