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: 
salleninsd
Creator
Creator

Syntax question for Month number in set analysis

Hello,

I am having trouble with the syntax in my set analysis.  I am trying to change the top formula to a formula that adjusts for each month as the year progresses.  I need help with the syntax in the bottom formula:

[AEQuota.QuotaMonth]={">=1 <=11"}

[AEQuota.QuotaMonth]={">=1 <=Num(Month(Date(($(vLastMonthEnd)))))"}

 

vLastMonthEnd is a variable that returns 2018-11-30, so I'm trying to get to the month number in the formula.

Thanks in advance for any help you can provide!

Scott

1 Solution

Accepted Solutions
salleninsd
Creator
Creator
Author

Hello Rob,

I think I figured it out.  I needed to create the variable first, then use it in the syntax.  It now works with the variable that I created:

[AEQuota.QuotaMonth]={">=1 <=$(vLastMonthNum)"}

 

Thank you so much for your quick response!  Have a great evening!

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you post the definition of vLastMonthEnd?

 

-Rob

salleninsd
Creator
Creator
Author

Please disregard.  I figured out that I should create the variable first, then use it in my syntax.

Solution works:

[AEQuota.QuotaMonth]={">=1 <=$(vLastMonthNum)"}

salleninsd
Creator
Creator
Author

Hello Rob,

I think I figured it out.  I needed to create the variable first, then use it in the syntax.  It now works with the variable that I created:

[AEQuota.QuotaMonth]={">=1 <=$(vLastMonthNum)"}

 

Thank you so much for your quick response!  Have a great evening!