expression not giving correct result

[sakshikaul]

Hi All

In the below chart I want when user selects date range From calender  then sales for entire date range should be depicted in chart

Here In MRP daily Target sale is coming out to be 0

Following expression is used

=num(sum({<Sold_Date={">=$(From)<=$(To)"} >}DISTINCT Budget))

What all changes  are required in expression

[neelamsaroha157]

try removing the $ sign from 'From' and 'To' variables.

Test the value in a text box to confirm that the values in the variables match the Sold_Date format.

[sakshikaul]

STILL SAME PROBLEM EXISTS

[jayanttibhe]

Hi,

There is two special operators called precedes and follows that could be used in your case I think:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/Operators/Rela...

Try this ::

=num(sum({<Sold_Date={"'$(From)' precedes '$(To)'"} >}DISTINCT Budget))

[sakshikaul]

Hi

Its not giving result

From this expression

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

I am getting values but all are same under MRP daily target heading. so here values should be distinct so what all changes are required

[jayanttibhe]

Sample QVW please.

[qlikviewwizard]

Best way to get the better and quick solution is providing sample data and expected result.Thank you.