Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

interview question


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?

5 Replies
MVP
MVP

Re: interview question

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
Valued Contributor III

Re: interview question

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
Valued Contributor

Re: interview question

PFA...optimize qlikview Application

mohammadkhatimi
Valued Contributor

Re: interview question

PFA...valuelist and valueloop functions

mohammadkhatimi
Valued Contributor

Re: interview question

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

Community Browser