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

Set Expression with a Variable

Hello,

I am trying to calculate the total sales for the current week. "MaxWeek" is my Variable. "Dollar Sales" is my field. I am entering the expression below but not getting any results. Can someone please guide me to the correct expression?

sum({
    <[Date]= { "$(MaxWeek)" }>
    }
    [Dollar Sales]
    )

*MaxWeek==Date(Max({1<Date=$::Date>} Date))*

Labels (3)
1 Reply
PrashantSangle

what is error you are getting?

what is expression MaxWeek contain

You can debug your own expression by taking it table

in Expression editor put your expression at bottom of expression window you will see what it is evaluating?

If that debug won't work for you then please share with us the snip of it. 

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂