Min and Max Date inside set Analysis - QlikView

[Anonymous]

Hi guys,

I've attached an qvw sample and a excel file with the expected output. See Sheet 2 of qvw app.

In table Table Dates, I want to show the sum of value of the min date and max date of each code, using FactFaseActive = P

Showing only the dates corresponding to each code I can get the correct dates,

but using that formula in set analysis for sum sales, I can't.

It only gives the min and max of all dates.

Can you please help?

How can I get to the expected output (in yellow)?

Thanks in advanced,

Sílvia

[sunny_talwar]

I am glad I was able to help Silvia. Do I have two coffees now

[Anonymous]

To the rhythm to which I ask questions and you answer, I will consider buying a coffee machine soon