Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

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
sunny_talwar

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
Gysbert_Wassenaar

Max(Month)?


talk is cheap, supply exceeds demand
settu_periasamy
Master III
Master III

May be like this?

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

Chanty4u
MVP
MVP
Author

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)

tamilarasu
Champion
Champion

Hi Chanty,

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

agni_gold
Specialist III
Specialist III

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

sunny_talwar

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

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

Kushal_Chawda

try this

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