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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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 (1)
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