Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can anyone explain Performance tuning techniques in qlikview .
Hi,
Performance Tuning can done in script and design. Follow is few which i know
Backend:
- Avoid Calculated in UI instead i would prefer to use in script if it is possible
- Try to drop all fields which are not usable in design and load very less data if not needed. Ex - If you have data around 20 years data then load only 2 years data
- If you are loading tables which is similar try to store in QVD and use that.
- Flags are very powerful. You can use as many you want call them in set analysis for better performance.
Frontend:
- Use Set Analysis as much as possible.
- Try to use charts using Hide and Show future
- Restrict charts for only one chart and create buttons will reduce and save the time to Save(Ctrl+S)
- Calculated dimension is not the good idea, If so - Try using that Calc. in measure
- If..Else consume RAM instead Pick..Match can save some memory
Does it make sense??
on top of what @Anil mentioned, I like to use this tool:
Search Recipes | Qlikview Cookbook
Hi,
Please Open Below Link it My Help You
Bardess Group: Business Analytics & Data Strategy. 973-584-9100