Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Rocky6
Creator
Creator

Find values for BOM of Month

Hi All,

i need a set analysis to find BOM of each month. 

For Ex: Currently we are in May, I need to find the value for BOM for april 2023. 

My date field is Month and measure name is Premium. 

* BOM : Beginning of Every month.

Thanks in Advance

 

2 Solutions

Accepted Solutions
Rocky6
Creator
Creator
Author

I have two date fields as i am joining two tables.

Date field is from master table 

Filedate is from Joining table.

So how to add this date fields in the set. 

Thanks in Advance 

View solution in original post

Kushal_Chawda

@Rocky6  try below

=sum({<FileDate = {"$(=monthstart(addmonths(max(CalendarDate),-1)))"}>}Value)

View solution in original post

5 Replies
deepanshuSh
Creator III
Creator III

Hi There, 

You can use the following code for getting BOM

Monthstart(Monthname(today())-1)

Trial and error is the key to get unexpected results.
Kushal_Chawda

@Rocky6  considering you have Date field in your data use below expression

=sum({<Date = {"$(=monthstart(addmonths(max(Date),-1)))"}>}Value)
Rocky6
Creator
Creator
Author

I have two date fields as i am joining two tables.

Date field is from master table 

Filedate is from Joining table.

So how to add this date fields in the set. 

Thanks in Advance 

Kushal_Chawda

@Rocky6  try below

=sum({<FileDate = {"$(=monthstart(addmonths(max(CalendarDate),-1)))"}>}Value)
Rocky6
Creator
Creator
Author

Thank you its working fine.