Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Vern2022
Contributor III
Contributor III

Creating Master Dimension to Only Return Months in a Particular Year

Hi,

I have a large data set which dates back to 2008 from now but I only want the graph to display months for this financial year. So I thought to create a dimension in Masters using the syntax below but all columns are being returned. Can you please advise me what I am doing wrong. Many thanks.


This is my code:

=if([Financial Year] >= '2022/23',[Financial Year Month])

 

Many thanks.

Labels (7)
1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Let's see your master calendar script.