Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

How to fetch multiple values from the filter using max function

Hi

I want to fetch multiple values from month filter where the month is the maximum in a quarter

snip1.JPG

for ex it should show me data of the maximum month for quarter 2 i.e. Sep, when I select Q1 and Q2 it should show me data for Sep month and June month summed up

18 Replies
siddharthsoam
Partner - Creator II
Partner - Creator II
Author

I don't have a date field , I have quarter filter and month filter where months are derived for their respective quarters

shraddha_g
Partner - Master III
Partner - Master III

Do you have Year Field?

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Yes I have a year field as well named Fiscal Year

shraddha_g
Partner - Master III
Partner - Master III

is it possible for you to share sample app?
siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Hi Shradha,

PFA of the sample qvf file

shraddha_g
Partner - Master III
Partner - Master III

PFA as required

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Thanks shraddha

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Shraddha if I have my year format as FY17 , how do I use it in date# function

shraddha_g
Partner - Master III
Partner - Master III

Date#(mon & ' ' & purgechar(Year,'FY'),'MMM-YY')