topic Alternate to display large sets of data in QlikView https://community.qlik.com/t5/QlikView/Alternate-to-display-large-sets-of-data/m-p/1332834#M411561 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have created the straight table with 80 columns and 5 different expressions with 6 million records. So I gave options to the users to select at least one dimension and expression manually to see the data on the dashboard.</P><P></P><P>All the calculations for the expressions are done in the backend. Now I am trying to display data for one month with all the dimensions and expressions selected, which has around 100k rows of data.</P><P></P><P>My RAM capacity is 1TB and my application is using 250 GB RAM.</P><P></P><P>Even with the large amount of memory left in RAM, my application is taking forever to display.</P><P></P><P>Does anyone know what is causing this?</P><P></P><P>According to my knowledge, once aggregations are stored in RAM, it shouldn't take much time to display.</P><P></P><P>Please correct me, if I am wrong.</P><P></P><P>Thanks,</P><P>VK</P></BODY></HTML> Mon, 03 Apr 2017 17:20:49 GMT varunreddy 2017-04-03T17:20:49Z Alternate to display large sets of data https://community.qlik.com/t5/QlikView/Alternate-to-display-large-sets-of-data/m-p/1332834#M411561 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have created the straight table with 80 columns and 5 different expressions with 6 million records. So I gave options to the users to select at least one dimension and expression manually to see the data on the dashboard.</P><P></P><P>All the calculations for the expressions are done in the backend. Now I am trying to display data for one month with all the dimensions and expressions selected, which has around 100k rows of data.</P><P></P><P>My RAM capacity is 1TB and my application is using 250 GB RAM.</P><P></P><P>Even with the large amount of memory left in RAM, my application is taking forever to display.</P><P></P><P>Does anyone know what is causing this?</P><P></P><P>According to my knowledge, once aggregations are stored in RAM, it shouldn't take much time to display.</P><P></P><P>Please correct me, if I am wrong.</P><P></P><P>Thanks,</P><P>VK</P></BODY></HTML> Mon, 03 Apr 2017 17:20:49 GMT https://community.qlik.com/t5/QlikView/Alternate-to-display-large-sets-of-data/m-p/1332834#M411561 varunreddy 2017-04-03T17:20:49Z