Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Champion III
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?

/Thanks in advance.

Best

Chanty

1 Solution

Accepted Solutions

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

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

View solution in original post

7 Replies
MVP & Luminary
MVP & Luminary

Max(Month)?


talk is cheap, supply exceeds demand

May be like this?

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

Champion III
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)

Hi Chanty,

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

Specialist III
Specialist III

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

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

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

View solution in original post

MVP
MVP

try this

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