Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajitkjain
Partner - Contributor
Partner - Contributor

Optimize User Experience with UI

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.

7 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

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

 

qliksus
Specialist II
Specialist II

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

ajitkjain
Partner - Contributor
Partner - Contributor
Author

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
Partner - Contributor
Partner - Contributor
Author

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
Partner - Specialist III
Partner - Specialist III

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

Any complex expressions like aggr?

Or it is done by set analysis?

Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.