Value for Max Month.

coolwaters — Mon, 02 Apr 2012 19:39:25 GMT

Hello,

i am trying to find a way to achive the following.

Have one bar chart with cyclic dimension, Year & Quarter.

Have two expressions, One for showing the total sales which is working fine.

Need help with the expression for closing stock. I have the closing stock for each month in the table.

If Year is selected as the dimension then the closing stock needs to be for the max month of that year.

If Quarter is selected then the closing stock needs to be for the max month of each quarter.

Can this be achieved via one expression.

Hope i am able to put forth my requirement clearly.

Thanks.

jagan — Tue, 03 Apr 2012 05:09:05 GMT

Use this expression

=Sum({<Month={'$(=Month(Max(DateFieldName)))'}>} ClosingStock)

Hope this helps you.

Regards,

Jagan.

topic Value for Max Month. in QlikView