topic Re: value at maximum month in cyclic group in QlikView

value at maximum month in cyclic group

harleen_singh — Thu, 06 Feb 2014 05:44:52 GMT

Hii,

I have created a cyclic group between Yearmonth and a Year.

So, when user see data at Month level it should show monthly data that's fine.

but when choose Year(in cyclic group). I want to show Value for the maximum Month for that Year.

so if data is like this for MonthYear

Jan Feb Mar Apr

20 30 20 50

so when user choose Year(in cyclic Group)

It should show

Year

I am trying this formula but it is not working

=Sum({< Month={'$(=Month(Max(Date)))'}>} countofincidents)

thanks

lavi

Thu, 06 Feb 2014 07:02:15 GMT

try using

if(GetCurrentField(<CyclicGroupName>)='Year',Month(Max(Date)))

harleen_singh — Fri, 14 Feb 2014 09:02:28 GMT

Nagaraj,

it did not worked. Well i am not looking for Maximum date, I am looking for Value at Maximum date.

thanks

Lavi

Fri, 14 Feb 2014 13:09:31 GMT

Hi Lavi, You can directly use the Expression in your cyclic Group

YearMonth --> YearMonth

Year --> Aggr(Max(Month) , Year)

harleen_singh — Mon, 17 Feb 2014 05:16:13 GMT

Dathu,

it returns maximum month in cyclic group that is ok.

but i want to return also the "Value" at maximum month

value in my case is "countofincidents"

thanks

Lavi

Mon, 17 Feb 2014 14:35:11 GMT

If the Dimension have max Month value, the expression returns the coountofincidents for that month.

CountofIncidents is a expression or ?