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: 
arvind_patil
Partner - Specialist III
Partner - Specialist III

How to write Set analysis for below condition

Hi Experts,

Please help me below thread.

I have master calendar in that  I have  Year, Month Quarter Fields. I want write  expression like below.

1. If I have select any year  then values should display next year first month.

  for e.g: If  I have select  fin Year 2017-18 then values display April 2018

              If  I have select  fin Year 2016-17 then values display April 2017

2. If I have not done any selection then values should only max month.

3. If I Have select max FinYear then values should max month.

Thanks & Regards,

Arvind Patil

7 Replies
rangam_s
Creator II
Creator II

If possible, Can you Attach you qvf file ?

arvind_patil
Partner - Specialist III
Partner - Specialist III
Author

Sorry to say but i cant attach Qvf file .

If you require more clarification then i will provide you.

Regards,

Arvind Patil

rangam_s
Creator II
Creator II

Can you tell me on what all the Calendar Related Fields available in data, along with sample of 2 transactions.

renuka_sasikumar
Creator III
Creator III

How about this one.

=If(GetSelectedCount([Fin-Year])>=1,SUM({<MonthName={'$(vMinMonth)'}>}Value),SUM({<MonthName={'$(vMaxMonth)'}>}Value))

Regards,

Renuka S

MK9885
Master II
Master II

You selecting single Year or Multiple year?

If you select 2018, it should show the month start from apr?

And if you select 2017, month should start from 2017-Apr?

or Just show Apr month if a Year is selected and then you manually select other months?

Anonymous
Not applicable

Hi!

Check this:

Store the max finyear in a variable ($(maxFinyear))

If(Finyear<>$(maxFinyear), Monthname(yearstart(addyears(Finyear,1))), month(max({1}Finyear)))

RC

mithilesh17
Partner - Creator II
Partner - Creator II

Hi AP,

Try with making new field as left([Fin Year],4) as [Fin Year New]

then

if([Fin Year New]-=vMaxFinYear,vNextYearMonthStart,vMaxMonth)

Just a rough idea.

Regards,