topic Re: Data filter in QlikView

Data filter

subbareddykm — Tue, 19 Jan 2016 16:06:26 GMT

Hi All,

I have one requirement,i tried a lot but i m not able to get that.

For example :

i have fields like ID, Type, Date and Time.

What i want is

For every ID , If Type=A and Max(Date) and Max(Time)

Note :

1. If ID is having no of dates select max date and pick max time .

2. If ID is having Same date and diff time pick accoding max time

3. Only for Type = A

subbareddykm — Tue, 19 Jan 2016 16:43:20 GMT

Can any one help me on this ?

settu_periasamy — Wed, 20 Jan 2016 02:48:47 GMT

subbareddykm wrote:

i have fields like ID, Type, Date and Time.

In your attachment there is no Date and Time Field. Can you Post your output also?

manojkulkarni — Wed, 20 Jan 2016 04:26:17 GMT

what is your expected output ?