Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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
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 =
Hi Chowdary,
Please look it the Help of Qlikview.
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