Optimize User Experience with UI

[ajitkjain]

Hi,

In my dashboard there are two tables, one transaction and one Dimension table and both are connected via a numeric key. When selecting, any dimension from filter panel (we have 5 dimension filter), it takes some time to reflect the same. So, is there a way to enhance the User experience as User has to wait more than 1 min to apply 5 filters.

[Arthur_Fong]

Try to check if there is any synthetic key or circular loops in your data model.

[qliksus]

The culprit is the calculation happening when you make the selection . Do you have any complex calculation in the chart  ?

[ajitkjain]

We dont have any circular loops or Synthetic keys in the data model. There are a millions of transactions on which the filter applies and user has to wait to apply all the filters as qlik filters or slices / dice the data based on each selection as per associative property. So, is there a way to only apply filters first and then on any action or on button click the calculation or  the slicing and dicing of data happens in the qvw?

[ajitkjain]

We have at least 100 KPIs in dashboard and most of them are used for comparison by selecting 2 different KPIs from drop down, and the main issue is the wait time for user to apply all filters. Hence, User experience is bad.

[Arthur_Fong]

How is the expression for those 100+ KPIs looks like?

Any complex expressions like aggr?

Or it is done by set analysis?

[Arthur_Fong]

You can refer to this post to add trigger when opening the qvw:

https://community.qlik.com/t5/QlikView-App-Development/Default-selections-on-document-opening/td-p/8...

[Brett_Bleess]

Another option would be to use the Calculation Condition option in the chart properties and the GetSelected Count I believe to not run the calculations until the user has made the selections you wish to force in the list boxes...  

The following Design Blog may shed some light upon things for you regarding the why:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Calculation-Engine/ba-p/1463265

See the following and the Calculation Condition option:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartProperties...

I think the following post may be what you could use:

https://community.qlik.com/t5/QlikView-Layout-Visualizations/Calculation-Condition/m-p/827027#M50235

Hopefully one or all of these help!

Regards,
Brett