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: 
Anonymous
Not applicable

Current Month Revenue Display

Good morning everyone,

I have revenue data from two different months. When I go into my Qlik Sense sheet, my revenue formula sums the two months together until I choose a specific month with my filter pane. Is there a way I can write into the formula to automatically select the current month or max month when the revenue data is unselected?

I assume this can be done with a set modifier pointing to latest, current, or max month?

Thanks everyone!

11 Replies
Anonymous
Not applicable
Author

I tried this equation, but I just get all zeros across my revenue column data...

=sum({<Month={"=$(=Max(Month))"}>}Revenue)

antoniotiman
Master III
Master III

Try

sum({<Month={"$(=Max(Month))"}>}Revenue)

devarasu07
Master II
Master II

Hi,

try like this,

add in your script,

num(Month(Date)) as Month# // update your date field name here

create Measure like below using set analysis expression

sum( {$<Year={"$(=max(Year))"},Month# ={"$(=max(Month#))"}>} Revenue)

Thanks,
Deva

Anonymous
Not applicable
Author

Still getting zeros here

Anonymous
Not applicable
Author

Hi There, my date field name is just Month, so in the "update your date field name here" reference you made above, would I just type Month in for that?

Thanks!

devarasu07
Master II
Master II

hi,


in this case, simply try like this way

Sum({<Month = {$(=MaxString(Month))}>}Revenue)


Capture.JPG

Anonymous
Not applicable
Author

The numbers are not lining up exactly when I select the month versus when I unselect all….but I am getting numbers

devarasu07
Master II
Master II

hi,

can you share your mock data and expected output in excel format. tks

Anonymous
Not applicable
Author

So this is giving the previous month, not the latest for some reason….