Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharthsoam
Contributor

Fetch max month value with respective to multiple quarters

Hi All,

I want to fetch  max values from the months filter with respective of quarters I select. So for example I select quarter 1 it should show me max month of quarter 1 i.e. june, if I select multiple quarters ex Q1,Q2 it should return june,sep

Quarter       Month

1               Apr,May,Jun

2               Jul,Aug,Sep

3               Oct,Nov,Dec

4               Jan,Feb,Mar

snip_cbu_newx2.JPG

2 Replies
shraddha_g
Honored Contributor III

Re: Fetch max month value with respective to multiple quarters

is it what you required?

PFA

agigliotti
Honored Contributor II

Re: Fetch max month value with respective to multiple quarters

you can get it using Max(Month) expression.