chart expression

[sakshikaul]

Hi

i want when user selects date from 1st june 2018 till 30th june 2018 MRP daily achievementss should depict sales for only 30Th june 2018 and further cumulative sales for entire selected date range ie1 st june 2018 till 30th june 2018.Following is the expression but its not working correctly

=num(sum({<Sold_Date = {"<=$(To)"} >}[sales price]* quantity_sold)

-

sum({<Sold_Date = {"<=$(To)"} >}[sales price]* quantity_returns)

what all changes are required in this expression?

[qlikviewwizard]

Can you attach the sample data and expected result?

[sakshikaul]

I can explain you in more detail.

i want suppose the user selects starting date as 1st June and end  date as 30th june 2018 so i want to write an expression

For which the data for 30th june (end  date) should only be depicted  in charts , so under MRP daily achievements the sale for 30th june 2018(end date should only be depicted)

=num(sum({<Sold_Date = {"<=$(To)"} >}[sales price]* quantity_sold)

-

sum({<Sold_Date = {"<=$(To)"} >}[sales price]* quantity_returns)

what all changes are required in this above expression?

[sakshikaul]

stalwar1‌ Please help

[Anil_Babu_Samineni]

Might date format issue for variable, does solddate and variable results same?

[qlikviewwizard]

Your question is a big challenge to understand.So please provide sample data and expected result.