topic Re: Set Analysis in QlikView

Set Analysis

Anil_Babu_Samineni — Mon, 20 Jun 2016 08:53:59 GMT

Hello,

If i select Year i want show Last date of the year using Set Analysis

For ref, PFA

antoniotiman — Mon, 20 Jun 2016 09:04:13 GMT

mightyqlikers — Mon, 20 Jun 2016 09:05:57 GMT

PFA.

$@M.

Anonymous — Mon, 20 Jun 2016 09:35:02 GMT

Hi Anil,

Try this expression:

Sum({<[Order Date Year] = {'$(=Max([Order Date Year]))'}

,[Order Date] = {'$(=max({<[Order Date Year]={$(=max([Order Date Year]))}>} [Order Date]))'}

>} Sales)

Regards!

Anil_Babu_Samineni — Mon, 20 Jun 2016 09:43:51 GMT

Manuel, Sam & Antonio,

Right. As per time Antonio is First one..