topic Re: How to fetch multiple values from the filter using max function in Visualization and Usability

How to fetch multiple values from the filter using max function

siddharthsoam — Thu, 09 Nov 2017 05:33:04 GMT

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

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

Re: How to fetch multiple values from the filter using max function

poojashribanger — Thu, 09 Nov 2017 06:06:33 GMT

Hi,

You can use this expression

max(total MonthName)

Re: How to fetch multiple values from the filter using max function

OmarBenSalem — Thu, 09 Nov 2017 09:15:23 GMT

Create a new dimension as follow:

=aggr(max({$<Month = p({1<Month={"$(=max(Month))"}>})>} Month ),Month)

result:

Re: How to fetch multiple values from the filter using max function

siddharthsoam — Fri, 10 Nov 2017 05:59:40 GMT

Hi Omar

This function is returning me a single value. I want it to return me multiple values for quarter Q2 and Q3 that is 6 and 9.

Also it would be great if we take months filter not in numbers but in as text 1 for Apr and thereafter

Re: How to fetch multiple values from the filter using max function

shraddha_g — Fri, 10 Nov 2017 06:26:45 GMT

Please refer attached..Is this what s required?

Re: How to fetch multiple values from the filter using max function

siddharthsoam — Fri, 10 Nov 2017 06:40:08 GMT

Hi Shraddha that's exactly what I want minus the year

Re: How to fetch multiple values from the filter using max function

shraddha_g — Fri, 10 Nov 2017 06:45:46 GMT

PFA

Re: How to fetch multiple values from the filter using max function

siddharthsoam — Fri, 10 Nov 2017 06:55:48 GMT

Hi Shraddha

I am using the following expression

Concat( distinct { <Quarters=p(Quarters)>} Month(QuarterEnd),',')

but still not able to get the desired result. Its showing nothing on the KPI.

Re: How to fetch multiple values from the filter using max function

siddharthsoam — Fri, 10 Nov 2017 06:56:05 GMT

can you please share the qvf

Re: How to fetch multiple values from the filter using max function

shraddha_g — Fri, 10 Nov 2017 06:57:38 GMT

Do you have QuarterEnd Field Calculated in Backend?

if not,

Concat( distinct { <Quarters=p(Quarters)>} Month(QuarterEnd(DateField)),',')

At the place of DateField use your appropriate DateField

Re: How to fetch multiple values from the filter using max function

siddharthsoam — Fri, 10 Nov 2017 07:05:14 GMT

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

Re: How to fetch multiple values from the filter using max function

shraddha_g — Fri, 10 Nov 2017 07:09:22 GMT

Do you have Year Field?

Re: How to fetch multiple values from the filter using max function

siddharthsoam — Fri, 10 Nov 2017 07:32:32 GMT

Yes I have a year field as well named Fiscal Year

Re: How to fetch multiple values from the filter using max function

shraddha_g — Fri, 10 Nov 2017 08:23:50 GMT

is it possible for you to share sample app?

Re: How to fetch multiple values from the filter using max function

siddharthsoam — Fri, 10 Nov 2017 10:31:03 GMT

Hi Shradha,

PFA of the sample qvf file

Re: How to fetch multiple values from the filter using max function

shraddha_g — Fri, 10 Nov 2017 10:41:32 GMT

PFA as required

Re: How to fetch multiple values from the filter using max function

siddharthsoam — Fri, 10 Nov 2017 10:45:06 GMT

Thanks shraddha

Re: How to fetch multiple values from the filter using max function

siddharthsoam — Fri, 10 Nov 2017 10:57:38 GMT

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

Re: How to fetch multiple values from the filter using max function

shraddha_g — Fri, 10 Nov 2017 11:00:00 GMT

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