topic Re: Last store purchased in in QlikView

Last store purchased in

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am trying to find the last store someone purchased from.

I use the following expression and I expect one store name to be returned. However, in some cases I get two or more.

concat({<Accumulator_Type={'RETAIL'}, [Order_Date.autoCalendar.Date]={"=max([Order_Date.autoCalendar.Date])"}>}distinct Order_Channel_Name)

Can you help?

George

Re: Last store purchased in

Nagaraju_KCS — Mon, 12 Mar 2018 15:52:13 GMT

Your expression correct...

=concat({<OrderDate={"=max(OrderDate)"}>}distinct DivisionName, ', ')

Re: Last store purchased in

Anonymous — Mon, 12 Mar 2018 15:55:25 GMT

Thanks for your answer

This will just add a comma between values. I don't want that. I want to make sure only one store name is returned.

Re: Last store purchased in

Nagaraju_KCS — Mon, 12 Mar 2018 16:08:00 GMT

Like this ??

=SubField(concat({<OrderDate={"=max(OrderDate)"}>}distinct DivisionName,','), ',', 1)

Re: Last store purchased in

Anonymous — Mon, 12 Mar 2018 16:13:40 GMT

Thanks again

I tried this and it takes the first of the "list" that concat creates I want to make sure that concat returns only one value. I try this with max(Date) because it means that no customer can make a purchase in the same day in two different stores. However, I still get two or more stores per person for max(date) being the last purchase date

Re: Last store purchased in

Nagaraju_KCS — Mon, 12 Mar 2018 16:29:07 GMT

can you share sample data ??

Re: Last store purchased in

Anonymous — Mon, 12 Mar 2018 16:30:32 GMT

Unfortunately no