Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
ugurarslan
Creator
Creator

=day(today()) number to use in expression

Dear all,

I need to create a set expression where I need to look at data less than day number today.

The normal expression looks like this:

Sum({<[AR Day Nbr]={'<17'},[Event]={'APP'},[Cash App Type]={'CASH'}>} [AR USD]*(-1))

I need to automate this process with looking to AR day NBR '< day(today()).

I tried 

Sum({<[AR Day Nbr]={'< day(today())'},[Event]={'APP'},[Cash App Type]={'CASH'}>} [AR USD]*(-1))

but didn't work. 

Please help me.

Thanks

Ugur

 

 

Labels (3)
3 Replies
dplr-rn
Partner - Master III
Partner - Master III

Try
[AR Day Nbr]={"< $(day(today()))"}
sunny_talwar

I think you might have missed an equal sign
[AR Day Nbr]={"<$(=Day(Today()))"}

dplr-rn
Partner - Master III
Partner - Master III

thanks Smiley Embarassed