Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

harleen_singh
Not applicable

value at maximum month in cyclic group

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

50

I am trying this formula but it is not working

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

thanks

lavi

5 Replies
Not applicable

Re: value at maximum month in cyclic group

try using

 

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

harleen_singh
Not applicable

Re: value at maximum month in cyclic group

Nagaraj,

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

thanks

Lavi

Not applicable

Re: value at maximum month in cyclic group

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

YearMonth --> YearMonth

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

harleen_singh
Not applicable

Re: value at maximum month in cyclic group

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

Not applicable

Re: value at maximum month in cyclic group

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

CountofIncidents is a expression or ?