# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
cancel
Showing results for
Did you mean:
Champion III

## RE:Max in Quarter

Hi all,

I have  a  fileds lik

orderdate,

year,

quarter,

month

day,

so  in quarter i hve  Q1,Q2,Q3,Q4

so i need to Pick   Q2 max month  in set analysis

how can i get this  Max month?

Best

Chanty

1 Solution

Accepted Solutions
MVP

I think this should work. But if you have 1, 2, 3, 4 in Quarter field thin this:

=Max({<Quarter = {2}>}Month)

7 Replies
MVP & Luminary

Max(Month)?

talk is cheap, supply exceeds demand

May be like this?

quarter={'Q2'},month={"\$(=Max(Month))"}

Champion III

Hi settu,

set analysis i want to pick max month in Quarter 2 .my field name is qtr 1,2,3,4,

eg:sum({<FY={\$(=Max(FY))},Qtr={'2'},MonthOrder = {"\$(= max({<FY={\$(=max(FY))}>} MonthOrder)-8)"}>} Amount)

MVP

Hi Chanty,

What is the MonthOrder field values? What are you trying to acheive with this field?

Specialist III

=Max({<Quarter={'Q2'}>}Month)

MVP

I think this should work. But if you have 1, 2, 3, 4 in Quarter field thin this:

=Max({<Quarter = {2}>}Month)

MVP

try this

=sum({<FY={"\$(=Max(FY))"},Qtr={"2"},MonthOrder = {"\$(= max({<FY={"\$(=max(FY))"},Qtr={"2"}>} MonthOrder))"}>} Amount)