topic Re: performance tuning technique in qlikview in QlikView

performance tuning technique in qlikview

honeyasha — Wed, 25 Nov 2020 16:16:04 GMT

can anyone explain Performance tuning techniques in qlikview .

Re: performance tuning technique in qlikview

Anil_Babu_Samineni — Sun, 24 Jun 2018 07:47:12 GMT

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??

Re: performance tuning technique in qlikview

kfoudhaily — Sun, 24 Jun 2018 10:54:59 GMT

on top of what @Anil mentioned, I like to use this tool:

Search Recipes | Qlikview Cookbook

Re: performance tuning technique in qlikview

sujan24s — Mon, 25 Jun 2018 05:54:55 GMT

Hi,

Please Open Below Link it My Help You

Bardess Group: Business Analytics & Data Strategy. 973-584-9100