Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Chanty4u
Esteemed Contributor 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

Re: RE:Max in Quarter

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

Re: RE:Max in Quarter

Max(Month)?


talk is cheap, supply exceeds demand

Re: RE:Max in Quarter

May be like this?

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

Chanty4u
Esteemed Contributor III

Re: RE:Max in Quarter

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)

Re: RE:Max in Quarter

Hi Chanty,

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

agni_gold
Valued Contributor III

Re: RE:Max in Quarter

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

Re: RE:Max in Quarter

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

Re: RE:Max in Quarter

try this

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