topic Re: How to Select multiple Max(Date) for different products? in QlikView

How to Select multiple Max(Date) for different products?

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

Hi ALL,

I have Different products as below

Product Date

---------- --------------------

A 12/28/2016

B 12/27/2016

C 12/28/2016

taking straight table implemented expression with set analysis , now my concern is if i select product A in list box it is showing (max(Date)), when i am selecting A and B same time it return '12/28/2016' only i want to display product A and B Dates individually

Regards,

Nagesh

Re: How to Select multiple Max(Date) for different products?

Anil_Babu_Samineni — Wed, 28 Dec 2016 09:00:05 GMT

You may describe more, For me it is working

If I select A&B from list box

I got like below, Can you describe more the part of Set Analysis

Re: How to Select multiple Max(Date) for different products?

Wed, 28 Dec 2016 09:04:11 GMT

If you have multiple dates for your each product then use the below steps

1. Take straight table add Product

2. Add calculated dimension in that use Max(Date)

3. Use your expression.

Re: How to Select multiple Max(Date) for different products?

Anonymous — Wed, 28 Dec 2016 09:27:20 GMT

hi Anil,

Please look into sample.qvw

>> If i select both products i need to display both dates but i was able to display only max date between two products

Re: How to Select multiple Max(Date) for different products?

Anonymous — Wed, 28 Dec 2016 09:29:52 GMT

Hi Uma,

Can you please look into sample.qvw

Re: How to Select multiple Max(Date) for different products?

johnw — Wed, 28 Dec 2016 21:03:31 GMT

Set analysis is not sensitive to the dimensions of the chart. But it seems like you're making this way more complicated than it needs to be unless I've misunderstood the requirement. It seems to me your expression in the sample file should just be this:

max([Latest Flag])

I could definitely have misunderstood what you're after, of course.

Re: How to Select multiple Max(Date) for different products?

Anonymous — Thu, 29 Dec 2016 03:24:29 GMT

Hi John

Thanks for ur reply, my condition is [Latest Flag]=max([Latest Flag]).

Re: How to Select multiple Max(Date) for different products?

tyagishaila — Thu, 29 Dec 2016 04:56:17 GMT

Try it,

Remove total

=only( {<[Latest Flag]={"=[Latest Flag]=timestamp(max( ([Latest Flag])))"}>} [Latest Flag] )

Re: How to Select multiple Max(Date) for different products?

Anonymous — Thu, 29 Dec 2016 08:54:24 GMT

Hi,

If I Remove total Count is miss matching .

Re: How to Select multiple Max(Date) for different products?

tyagishaila — Thu, 29 Dec 2016 09:07:05 GMT

Shared sample app has no count???..

Please share sufficient data with required output to resolve the issue.

& your current expression set analysis is not correct

=only( {<[Latest Flag]={"=[Latest Flag]=timestamp(max( ([Latest Flag])))"}>} [Latest Flag] )

no need to write [Latest Flag] twice.

Re: How to Select multiple Max(Date) for different products?

Anonymous — Thu, 29 Dec 2016 09:07:51 GMT

Hi Nagesh,

Try below expression:

Aggr(Max(Date), Product)

Re: How to Select multiple Max(Date) for different products?

Anil_Babu_Samineni — Thu, 29 Dec 2016 09:08:39 GMT

In your Data only two products are there?

Just use simple this =only([Latest Flag]) and then Select from List box.

Re: How to Select multiple Max(Date) for different products?

Anonymous — Thu, 29 Dec 2016 09:25:24 GMT

Hi,

Use below expression to find out max date by Product wise.

=Date(Aggr(Max(Date),Product),'MM/DD/YYYY')

Warm regards,

Venkata Sreekanth