Qlik Community

Ask a Question

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY

QMC - please change inefficient filter/query execution processes

Ken_T
Creator
Creator

QMC - please change inefficient filter/query execution processes


As it is, I spend a lot of my time, waiting for the QMC to finish running a query that I actually did not want it to run, because I want results based on more than one column filter.

I would like to propose that this behavior be changed to improve usability and improve system performance.

There should be a button that executes the query, instead of having the query execute every time anything changes. This will allow the user to enter in all the details for their query, perhaps for 2 or more columns, and not have to wait in between for the QMC to process each part (wait for the answer to the wrong question), which for long lists can be slow and annoying. 

If you think there are some user out there that want to keep the current behavior,  perhaps a toggle shown on the screen to allow the user to  indicate if they want to utilize this improved behavior.   (Ideally, there should be a user's profile area where preferences could be set, but that is another idea)

Tags (2)
4 Comments
John_Teichman
Employee
Employee

Hello @Ken_T,

Thank you for your submission. Going forward please use one, and only one, label when submitting an idea. Please refer to the submission guidelines for more details.

Thomas_Hopp
Employee
Employee

Hi @Ken_T and thank you for sharing this idea with us. I'm changing the Status to "Delivered" as we did actually delivered a few things within that area.

1. Caching in the QMC which allows you to switch between tables much quicker without loading the whole table again

2. Bookmarks based on filters you can define yourself in the QMC

3. AMC for task management if you have users using the QMC only for Task Management, they can use the AMC (Application Management Console) as well. And we are adding the ability to manage & create your tasks as well into the Hub. Some of it will be there already in February on top of what we delivered in November. And there is more to come in April next year where the plan is to allow you as well to create and manage tasks in the Hub.

Let me / us know if those improvements I just mentioned are helpful for your scenario.

Regards,

Thomas

Status changed to: Delivered
Ken_T
Creator
Creator

I would consider this not delivered, any time I change a value that I searched for, the entire list refreshes, and I have to wait for it to show me results that I do not want to see, before I can then type in criteria in another column to see the results I actually want to see. As it is, this is terribly inefficient, and very bad usability.  If I want to search for a specific user by email, I have to first wait for it to show me a list of users I do not want to see. then I query for the one I want to see. suppose I then want to search by a user custom property.  I add the column as it is not visible at default.  I then have to wait for it to build a list of results i do not want or need to see.  Then, I can query for the result i need.  each wait, adds up.  If there was an execute query button, this would save so much time, and qlc users would not have to wait for results to questions that they did not want to ask, over and over and over again, every day.

Ken_T
Creator
Creator

this is 100% not delivered ! 🙂