Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

How to handle a report with 400 Million rows in QlikSense

Hello Friends,

I appreciate your time.  I have an issue in creating a chart which should take 40 Million rows while opening. Is there any way using extension or any other approach to achieve this ?

Could you kindly let me know your opinion?

Thank you,

Kiruthiga

 

 

2 Replies
Highlighted
Specialist
Specialist

Could be better with proper qvd management, but I also want to know about the same.
@sunny_talwar ,@swuehl , @rwunderlich  any suggestions Sir?

Highlighted
Partner
Partner

Below is my scenario:

I have a transaction fact with customers and trans_id which is connected to dimension product_table via prod_id.
When I try to create a chart for customer's trans_id count  for the products,
I always end up in out of memory due to high volume of trans_id associated for a customer. I can't split this report further down as this is at the aggr level we are looking for.

As of now I am creating a straight table and using the product_id as dim and count(trans_id) as exp.


Instead can we do some thing in the qvd layer to get the count of transactions and display in a table box will
resolve this issue?

 

could you let me know your suggestions or feedback?

 

Thank you,

Kiruthiga