Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anup_A
Contributor
Contributor
‎2020-03-09 08:36 AM

Using Condition for the Quarters derived using Mastercalendar

I am getting values Q1,Q2,Q3,Q4 in FQuarter field.

Now i am trying to compare value present in FQuarter and based on that I need to perform certain calculation.

  • If FQuarter is equal to 'Q1' and starting month for current quarter is Jan then I need to add 1 to the existing FY else I need to deduct 1 from existing FY.

Script I have written is

If(
Match(FQuarter,'Q1') and (month(QuarterStart(today(),0) = 1)), year(Addyears(Date(FYQ1_Start),1)),year(Addyears(Date(FYQ1_Start),-1)))

But above script is executing second condition only and it is deducting 1 every time.

FYQ1_Start =  04/01/2019 and output from above script is 2018.

Can anyone please help if anything wrong I have done here.

 

263 Views
0 Likes
0 Replies