topic Re: need help reg questions in QlikView

need help reg questions

Tue, 14 Jan 2014 05:12:45 GMT

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 ?

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

Re: need help reg questions

sujeetsingh — Tue, 14 Jan 2014 05:31:28 GMT

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

Re: need help reg questions

Tue, 14 Jan 2014 05:45:23 GMT

Hi Chowdary,

Please look it the Help of Qlikview.

Re: need help reg questions

mjm — Tue, 14 Jan 2014 08:46:11 GMT

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