Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
elie_issa
Creator II
Creator II

Qlik Sense Performance Issues

Dear All,

We are working on HR dashboard where we are trying to get the Data of each employees to be on daily basis and we are making the link with the master calendar table.

The main issue is that we are duplicating the data , and now the dashboard is including more than 100 millions of records (0.5 GB)

When trying to access the dashboard it's taking too much time to open the KPIs and the charts.

Any idea what could be the main issue or what we should check to enhance the performance of our dashboard.

Thanks for your support.

13 Replies
awhitfield
Partner
Partner

Hi Elie,

are you using Sense OR Sense Desktop?

Best regards

Andy

elie_issa
Creator II
Creator II

Sense

bill_markham

Could you expand on when you say we are duplicating the data ?

Clever_Anjos
Employee
Employee

It would be easier to help if you attach more information

you data model or script would help

igdrazil
Creator III
Creator III

Hi Elie,

can you provide your data model and possibly the specs of the machine you're running Qlik Sense on?

Regards

Chris

elie_issa
Creator II
Creator II

to simplify the case :

we have data for every employee on one record from start date to end date.

what we are trying to do is to create transactions by dates from the start date to the end date for these employees so we will have multiple records for the same employee so we can link it to our master calendar table and get the employees data on daily basis

hope i am clarifying well the case.

  

bill_markham

To quantify data volumes can you advise :

  • How many unique employees
  • How many unique dates
  • Total count of data rows

From that you should be able to derive average number of rows per employee per date.

The reason I ask is I that was surprised when you advised you have 100+ million rows.

elie_issa
Creator II
Creator II

qvf script attached.

Thanks for your support.

elie_issa
Creator II
Creator II

specs of the Server : 128 RAM 4 Core CPUs (around 300 users)