performance issue in charts

vb00494773 — Wed, 25 Nov 2020 16:16:04 GMT

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

topic performance issue in charts in QlikView

performance issue in charts