How to handle a report with 400 Million rows in QlikSense

[skiruthigadevi]

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

[Shubham_Deshmukh]

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

[skiruthigadevi]

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