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

[Anonymous]

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

[Anil_Babu_Samineni]

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

[#3]

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.

[Anonymous]

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

[Anonymous]

Hi Uma,

Can you please look into sample.qvw

[johnw]

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.

[Anonymous]

Hi John

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

[tyagishaila]

Try it,

Remove total

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

[Anonymous]

Hi,

If I Remove total Count is miss matching .

[tyagishaila]

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.