need help reg questions

[#1]

1. In what situation, you have used for loop in the back end?

    2.What is dimensionality function?

   3.Have you used Conditional enable for dimensions and expressions. How and where and why?

Questions on functions like rangesum(), peek(), time functions.How and when did you use it ?

1. What steps needs to be followed to improve performance of qlikview application

[sujeetsingh]

For Dimensionality Go to

   http://community.qlik.com/thread/83322

http://community.qlik.com/thread/59050

We need calculation for dimension when we are having some calculated value required

RangeSum()=http://community.qlik.com/message/29499

peek=Peek into QlikView Peek() function

For best performance =

http://community.qlik.com/docs/DOC-4556

[#3]

Hi Chowdary,

Please look it the Help of Qlikview.

[mjm · Accepted solution]

Hello Mvrchowdary,

Santosh is right that you should look at the Help file for reference to particular functions like rangesum() and peek(), but I will try and answer your questions:

1. A For Loop is a type of iteration which will iterate through a data set for a defined about of time. Whilst a condition is not met, i.e For i=0 to 1

2. I am not sure about this, so you would need to google this or look in the help file

3. A conditional statement is used to control when an object or expression is enabled. For example using GetSelectedCount() on a field can ensure an item in a field has been selected before a chart is shown.

4. To improve performance in an application, you should try and limit the amount of calculations being made in sheets in an application. This means that every time a sheet is loaded or a selection is made, then this calculation is performed again. It is advised to have as many calculations in application variables or defined during the load script of the app. You should also try to avoid using a lot of conditional statements to control when an application is loaded. This is also checked every time a selection is made, and can take a lot of time and resources to calculate. You should restrict the number of these calculation conditions you use.

Please mark this as helpful if these answers help you.

Thanks,

Mark