topic Re: grouping in a table in QlikView

grouping in a table

Mon, 17 Aug 2015 11:37:33 GMT

Hi All,

I have teh data as given below. Need to bucket the instances.

Location	Name	Date	Message
Bangalore	B, Ananthakrishnan	2015-07-02	21
Bangalore	B, Ananthakrishnan	2015-07-07	9
Bangalore	B, Ananthakrishnan	2015-07-10	5
Bangalore	B, Ananthakrishnan	2015-07-12	241
Bangalore	B, Ananthakrishnan	2015-07-13	214
Bangalore	B, Geetha	2015-07-02	1473
Bangalore	B, Geetha	2015-07-07	1162
Bangalore	B, Geetha	2015-07-10	1158
Bangalore	B, Geetha	2015-07-13	1212
Bangalore	B,Harish	2015-07-12	83
Bangalore	B,Harish	2015-07-13	67
Bangalore	Babu, Bojanapu Dinakar	2015-07-02	653
Bangalore	Babu, Bojanapu Dinakar	2015-07-07	285
Bangalore	Babu, Bojanapu Dinakar	2015-07-10	268
Bangalore	Babu, Bojanapu Dinakar	2015-07-13	397

Final output in table should be as given below.

Bucket	Bangalore	Chennai
0-600	10	0
600-800	1	0
800-1000	0	0
1000-1500	0	4
>1500	0	0

Attaching my QVW file for reference

Re: grouping in a table

sunny_talwar — Mon, 17 Aug 2015 11:44:47 GMT

May be something like this?

Dimension 1:

=If(Message <= 600, '0-600',

If(Message <= 800, '600-800',

If(Message <= 1000, '800-1000',

If(Message <= 1500, '1000-1500', '>1500'))))

Dimension 2: Location

Expression: Count(Location)

Re: grouping in a table

sunny_talwar — Mon, 17 Aug 2015 11:47:43 GMT

Since Chennai is not there in your sample data, this is what you will get with the provided data:

Re: grouping in a table

Mon, 17 Aug 2015 12:20:34 GMT

Hi,

Its working for the sample data provided by me.BUt in actual i am getting the data from 3 data sources and concatenating them where i am giving alias name for the header related to Message in the 3 data sources as 'Messages'.in that case this code does not seem to work.Attaching the QVW for your reference. !