topic Re: RE:Max in Quarter in QlikView

RE:Max in Quarter

Chanty4u — Sun, 27 Mar 2016 08:43:17 GMT

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

Gysbert_Wassenaar — Sun, 27 Mar 2016 09:16:21 GMT

Max(Month)?

settu_periasamy — Sun, 27 Mar 2016 10:04:00 GMT

May be like this?

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

Chanty4u — Sun, 27 Mar 2016 10:21:19 GMT

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 — Sun, 27 Mar 2016 10:45:13 GMT

Hi Chanty,

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

agni_gold — Sun, 27 Mar 2016 10:51:32 GMT

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

sunny_talwar — Sun, 27 Mar 2016 11:03:49 GMT

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

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

Kushal_Chawda — Sun, 27 Mar 2016 11:43:51 GMT

try this

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