topic Re: Group with After Count Number in QlikView

Group with After Count Number

Mon, 10 Oct 2011 07:21:26 GMT

Hi,

I use a expression to coun(TicketNo).

for example:

TicketNo =count(TicketNo)

1 9

2 9

3 10

...

how can i group all count(TicketNo=9) in one... so that when i can click 9 it will show me 1 and 2

Thanks

SunilChauhan — Mon, 10 Oct 2011 07:26:55 GMT

please see the attached file.

hope this helps you

Mon, 10 Oct 2011 07:30:28 GMT

but now my situation is i do the count from the expression count(ticketNo) where i wish to group for the result not define by me...

its_anandrjs — Mon, 10 Oct 2011 07:32:48 GMT

Hi,

Make a new resident table and create a field there with count(ticketNo) and use this field to group

Rgds

Anand

SunilChauhan — Mon, 10 Oct 2011 07:42:15 GMT

see the attached file

hope this help you