topic expression change in QlikView

expression change

Wed, 20 Apr 2016 14:38:15 GMT

hi guys,

Dimension is : =Aggr(Date(Floor(DATE),'DD/MM/YY'),TicketNumber)

Expression is:

=Count({$<ID={1},TYPE={'In','Ext','Out'}>}1)

The above combination is giving perfect result out put as "total count of first id of ticket number" by date,but i need last id of ticket insted of first id number, last id will not be constant.

can u suggest some thing for that expression?

thanks

Re: expression change

sunny_talwar — Wed, 20 Apr 2016 15:24:58 GMT

Not sure what you trying to do, would you be able to share a sample?

Re: expression change

Wed, 20 Apr 2016 15:33:48 GMT

hi,

i'm trying to count number of tickets by date for max_id/latest_id and type of ticket is should be 'In',ext, or out.

I'm looking some thing like the belwo output:

Input
Date	Ticketnumber	Type	id
1/12/2015	100	In	1
1/12/2015	100	In	2
1/12/2015	101	out	1
1/12/2015	101	out	2
1/12/2015	101	out	3
1/12/2015	200	ext	1
1/12/2015	200	ext	2
1/13/2015	200	ext	3
1/13/2015	200	ext	4
1/15/2015	300	ort	1
output
Date	count
1/12/2015	3
1/13/2015	1

thanks

Re: expression change

Wed, 20 Apr 2016 17:00:28 GMT

any help?

Re: expression change

sunny_talwar — Wed, 20 Apr 2016 17:08:09 GMT

Are you over complicating things? May be you just need this:

Dim: Date

Expression: =Count(DISTINCT{<Type={'In','ext','out'}>} Ticketnumber)

Re: expression change

Thu, 21 Apr 2016 10:17:20 GMT

hi,thank for this.

I do not think DISTINCT will take max id for the above suggested expression calculation.

am i right? else pls correct.

Re: expression change

sunny_talwar — Thu, 21 Apr 2016 15:02:26 GMT

It won't, but not sure why you want to count just the max? the result should still be the same, isn't it?

Re: expression change

Thu, 21 Apr 2016 15:37:48 GMT

yes,tht's right...In real time data will come different ways there is possibility..so i need to focus on only max one.

thanks for your help.