topic Re: Optimize User Experience with UI in QlikView

Optimize User Experience with UI

ajitkjain — Wed, 27 Nov 2019 12:52:38 GMT

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.

Re: Optimize User Experience with UI

Arthur_Fong — Thu, 28 Nov 2019 06:34:36 GMT

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

Re: Optimize User Experience with UI

qliksus — Thu, 28 Nov 2019 10:16:24 GMT

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

Re: Optimize User Experience with UI

ajitkjain — Fri, 29 Nov 2019 02:47:56 GMT

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?

Re: Optimize User Experience with UI

ajitkjain — Fri, 29 Nov 2019 02:51:02 GMT

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.

Re: Optimize User Experience with UI

Arthur_Fong — Fri, 29 Nov 2019 03:03:24 GMT

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

Any complex expressions like aggr?

Or it is done by set analysis?

Re: Optimize User Experience with UI

Arthur_Fong — Fri, 29 Nov 2019 03:07:16 GMT

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/851695

Re: Optimize User Experience with UI

Brett_Bleess — Tue, 10 Dec 2019 14:33:31 GMT

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.htm

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