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: 
zied_ahmed1
Specialist
Specialist

Meaning of this expression

Hello,

I want to know the meaning of this expression :

sum({<[Month of date]= {">=$(=Date(Month(), 'DD/MM/YYYY'))"}>}Sales)

Thank you

1 Solution

Accepted Solutions
bertdijks
Partner - Contributor III
Partner - Contributor III

Hi Zied,

This Formula probably only give back nothing, sinds there is a error in the formula. It means:

Show Sales where [Month of date] is equal or greater than the date of a month of nothing

View solution in original post

4 Replies
bertdijks
Partner - Contributor III
Partner - Contributor III

Hi Zied,

This Formula probably only give back nothing, sinds there is a error in the formula. It means:

Show Sales where [Month of date] is equal or greater than the date of a month of nothing

zied_ahmed1
Specialist
Specialist
Author

Hello Bert,

How i can select the Max of Month of date?

Thank you

Kushal_Chawda

sum({<DateField= {">=$(=monthstart(max(DateField)))<=$(=max(DateField))"}>}Sales)

Make sure that DateField is in proper date format, if not you need to make it in Date format, using Date# function in script

kkkumar82
Specialist III
Specialist III

How your months are calculated in the script ?

try this

Month(Max(Date))