interview question

[#1]

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?

[jagan]

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?

[ramasaisaksoft]

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

[mohammadkhatimi]

PFA...optimize qlikview Application

[mohammadkhatimi]

PFA...valuelist and valueloop functions

[mohammadkhatimi]

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