Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vb00494773
Partner - Contributor III
Partner - Contributor III

performance issue in charts

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

0 Replies