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: 
Not applicable

how can I enhance the performance of the qvw

I have a qvw with many data,about 1,000,000data.

the group leader want to see the aggregation of the data.and the department leader want to see the detailed.

how can I deal with this problem.

thanks

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

You can do the following to improve the performance.

1. While final load just load the columns you required.

2. Create 2 separate dashboards 1 for aggregation and one for detailed data.

3. Create QVD with raw data and process the data loaded from QVD's and then created another version of QVD's with aggregated or any other additional columns required.

4. Now use the final qvd's created above in the 2 separate dashboards 1 for aggregation and another for Detailed data.

Cheers.

View solution in original post

1 Reply
Not applicable
Author

Hi,

You can do the following to improve the performance.

1. While final load just load the columns you required.

2. Create 2 separate dashboards 1 for aggregation and one for detailed data.

3. Create QVD with raw data and process the data loaded from QVD's and then created another version of QVD's with aggregated or any other additional columns required.

4. Now use the final qvd's created above in the 2 separate dashboards 1 for aggregation and another for Detailed data.

Cheers.