topic Re: scenario in QlikView

scenario

Thu, 21 Apr 2016 16:22:09 GMT

hi guys,

can u suggest on below?

Input
TicketNumber	ID	TYPE
100	1	A
100	2	B
100	3	C
100	4	B
100	5	E
200	1	B
200	2	A
200	3	E
300	1	A
300	2	A
300	3	E
Output
300	1	A
300	2	A
300	3	E
Note: Ticketnumber consider for Type (A and E) only.

sunny_talwar — Thu, 21 Apr 2016 16:32:08 GMT

May be add ID as dimension

1) Max({<Type = {'A', 'E'}>}TicketNumber)

2) FirstSortedValue({<Type = {'A', 'E'}>} TYPE, -TicketNumber)

satishkurra — Thu, 21 Apr 2016 16:32:47 GMT

Create a calculated dimension as

=Aggr(Only({<Type={'A','E'}>}Type),TicketNumber)

satishkurra — Thu, 21 Apr 2016 16:33:33 GMT

Sunny out of curiosity, will the below expression works in this scenario?

sunny_talwar — Thu, 21 Apr 2016 16:37:33 GMT

I am not entirely sure what is the exact requirement, but it looks like going in the right direction

Thu, 21 Apr 2016 16:42:36 GMT

hi,thanks for kind response.

1) Max({<Type = {'A', 'E'}>}TicketNumber) -- given all the 3 ticket numbers

2) FirstSortedValue({<Type = {'A', 'E'}>} TYPE, -TicketNumber) --- not given any results.

any help?

Thu, 21 Apr 2016 16:43:11 GMT

hi,

this expression not given any results.

any help?

Thu, 21 Apr 2016 16:46:03 GMT

hi,

ticket number 100 went through multiple types in cluding A&E but 300 went through only A and E,so i need to consider that one only.

Fri, 22 Apr 2016 14:02:54 GMT

Is't possible to implement or not?

any idea guys,Gysbert,Swuehl,Sunny,Jagan?

thanks