Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vb00494773
New Contributor III

Performance issue in the front end

Hi all,

i am facing problem in the front end chart creation, charts are taking more time to reflect the data. 

sample data is below

tb:

Load * inline

[

   

field,date,value,quality
1,22-Mar,1,m
1,25-Mar,2,k
1,27-Mar,3,f
1,22-Mar,3,f
1,25-Mar,3,a
1,27-Mar,4,d
1,27-Mar,3,d
2,25-Mar,4,f
2,27-Mar,32,k
2,27-Mar,2,dd
2,20-Jan,2,d
2,21-Jan,2,d
2,22-Feb,2,m
3,23-Mar,7,k
3,2-Nov,66,f
3,3-Nov,55,f
3,3-Nov,44,m
3,4-Nov,2,k
3,4-Nov,2,f
3,5-Dec,4,f
3,5-Dec,6,m

];

the above table is the data format of my data ,however in the reality all my field names are coming under field values like 1,2,3 .

so i decided and converted whole data into fields by using generic load and used loop concept to stored all the tables formed under generic load as one table .so i got all my fields which under field column .

That table i am using for my front analysis (However the data size is almost 9 GB)  

Please suggest me a way to overcome this.

Thanks

Venkatesh

Community Browser