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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sakshikaul
Creator II
Creator II

relational operator not functionig properly

hi

Suppose,when user selects a date in calendar as 1st June 2018(from) till 30th June 2018(to) , here i only want to depict sales for the end date ie 30th june 2018 and all other data against each date should be 0

so in below expression =sign is not functioning

=num(sum({ <Sold_Date = {"< $(To)"} >} Target)  ,'#,##0.0')Paint1.png

3 Replies
sasikanth
Master
Master

Try this,


num(sum({ <Sold_Date = { "< $(=Date(To))"} >} Target)  ,'#,##0.0')


Anil_Babu_Samineni

As always, You are creating multiple threads for single issue. I suggest you to keep one only. Perhaps this?

=num(sum({ <Sold_Date = {">$(=From)< $(=To)"} >} Target)  ,'#,##0.0')

Or


=num(sum({ <Sold_Date = {">From< To"} >} Target)  ,'#,##0.0')

Or


=num(sum({ <Sold_Date = {">$(From)< $(To)"} >} Target)  ,'#,##0.0')


Finally, you must check how variables storing and Field values Sold_Date ??

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
ahmar811
Creator III
Creator III

Please use below expression

=num(sum({ <Sold_Date = {"$(=MonthEnd(Max(DateField)))"} >} Target)  ,'#,##0.0')


or


=num(sum({ <Sold_Date = {"$(=MontheEnd($(To)))"} >} Target)  ,'#,##0.0')


Regards

Ahmar