Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

grouping in a table

Hi All,

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

LocationNameDateMessage
BangaloreB, Ananthakrishnan2015-07-0221
BangaloreB, Ananthakrishnan2015-07-079
BangaloreB, Ananthakrishnan2015-07-105
BangaloreB, Ananthakrishnan2015-07-12241
BangaloreB, Ananthakrishnan2015-07-13214
BangaloreB, Geetha2015-07-021473
BangaloreB, Geetha2015-07-071162
BangaloreB, Geetha2015-07-101158
BangaloreB, Geetha2015-07-131212
BangaloreB,Harish2015-07-1283
BangaloreB,Harish2015-07-1367
BangaloreBabu, Bojanapu Dinakar2015-07-02653
BangaloreBabu, Bojanapu Dinakar2015-07-07285
BangaloreBabu, Bojanapu Dinakar2015-07-10268
BangaloreBabu, Bojanapu Dinakar2015-07-13397

Final output in table should be as given below.

 

BucketBangaloreChennai
0-600100
600-80010
800-100000
1000-150004
>150000

Attaching my QVW file for reference

Tags (1)
3 Replies

Re: grouping in a table

May be something like this?

Capture.PNG

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

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

Capture.PNG

Not applicable

Re: grouping in a table

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. !

Community Browser