Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
marjan_it
Contributor III

how to make rowno with aggr for grouping data

Hi all

I have a chat with  like this that have some filed. Messageid , Messagelogid, from date and to date. I want to add row no for each messahe id like the sample.

MessageidMessagelogidfromdateto daterow no
112013-10-23
2013-10-23
1
12
2013-10-23
2013-10-224
2
13
2013-10-24
2013-10-25
3
24
2013-10-23
2013-10-251
252013-10-252013-10-292
36
2013-10-25
2013-11-25
1
37
2013-11-25
2013-11-27
2

how can I built rowno in chart?!!

1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: how to make rowno with aggr for grouping data

Try this

Aggr(RowNo(),Messageid,Messagelogid)

7 Replies
antoniotiman
Honored Contributor III

Re: how to make rowno with aggr for grouping data

May be this

Autonumber(RowNo(),Messageid) as rowno

Regards,

Antonio

marjan_it
Contributor III

Re: how to make rowno with aggr for grouping data

No it dosnt work

antoniotiman
Honored Contributor III

Re: how to make rowno with aggr for grouping data

Why ?

LOAD *,AutoNumber(RowNo(),Messageid) as RowNo Inline [
Messageid,Messagelogid,fromdate,to date,row no
1, 1, 2013-10-23,2013-10-23, 1
1, 2,2013-10-23,2013-10-224, 2
1, 3,2013-10-24,2013-10-25, 3
2, 4,2013-10-23,2013-10-25, 1
2, 5,2013-10-25,2013-10-29, 2
3, 6,2013-10-25,2013-11-25, 1
3, 7,2013-11-25,2013-11-27, 2
]
;

marjan_it
Contributor III

Re: how to make rowno with aggr for grouping data

H want something work in expression not in script.

prma7799
Honored Contributor III

Re: how to make rowno with aggr for grouping data

Hi @antonio,

She wanted to this in front end ....

Thanks

antoniotiman
Honored Contributor III

Re: how to make rowno with aggr for grouping data

Try this

Aggr(RowNo(),Messageid,Messagelogid)

marjan_it
Contributor III

Re: how to make rowno with aggr for grouping data

thats work so good. thank you