topic Re: how write a group by clause in chart in QlikView

how write a group by clause in chart

Thu, 01 Nov 2012 15:53:59 GMT

Here is my data and would like to know how to write a group by date clause in q chart.

CREATE_DATE	MSG_TYPE_ID	MSG_ID
10/22/12 15:44		1000
10/22/12 14:59		1000
10/22/12 15:03		1000
10/22/12 12:36		1000
10/22/12 17:00		1000
10/22/12 13:35		1000
10/22/12 18:05		1000
10/22/12 18:20		1000
10/22/12 14:25		1000
10/22/12 13:02		1000
10/22/12 13:09		1000
10/22/12 18:40		1000
10/22/12 11:19		1000
10/22/12 15:06		1000
10/23/12 9:49		1000
10/23/12 8:57		1000
10/22/12 11:40		1000
10/22/12 14:40		1000
10/23/12 12:30		1000
10/25/12 14:17		1000
10/24/12 9:41		1000
10/22/12 18:15		1000
10/23/12 10:13		1000
10/23/12 8:58		1000
10/23/12 12:55		1000
10/23/12 9:49		1000
10/25/12 11:45		1000
10/22/12 16:33		1000
10/26/12 10:12		1000
10/25/12 14:36		1000
10/26/12 10:37		1000
10/22/12 11:20		1000

Re: how write a group by clause in chart

Thu, 01 Nov 2012 16:11:25 GMT

What is your expected end result?

Re: how write a group by clause in chart

hic — Thu, 01 Nov 2012 16:51:19 GMT

A chart always groups by the dimension. So you need to have a field that you want to group by and use this as dimension. Or you create a calculated dimension, e.g. =Month(CREATE_DATE). Then the aggregation (the expression) will be calculated for each value of the dimension.

HIC

Re: how write a group by clause in chart

preminqlik — Tue, 01 Oct 2013 19:49:04 GMT

take any chart except gauge ....while showing month as a group i think radar chart is best

write the dimension as

=month(date#(left(8),mm/dd/yyyy)

expression as sum(MSG_ID)

if u want to show trend take a line chart

take two dimensions

1.=year(date#(left(8),mm/dd/yyyy)

2.=month(date#(left(8),mm/dd/yyyy)

expression as sum(MSG_ID)

default chart shows group by itself....

-regards

premhas