topic relational operator not functionig properly in QlikView

relational operator not functionig properly

sakshikaul — Wed, 25 Nov 2020 16:16:04 GMT

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')

Re: relational operator not functionig properly

sasikanth — Wed, 04 Jul 2018 10:32:27 GMT

Try this,

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

Re: relational operator not functionig properly

Anil_Babu_Samineni — Wed, 04 Jul 2018 11:11:06 GMT

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')

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

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

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

Re: relational operator not functionig properly

ahmar811 — Wed, 04 Jul 2018 12:03:35 GMT

Please use below expression

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

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

Regards

Ahmar