topic Re: expression not giving correct result in QlikView

expression not giving correct result

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

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 — Tue, 03 Jul 2018 17:53:08 GMT

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 — Tue, 03 Jul 2018 18:15:36 GMT

STILL SAME PROBLEM EXISTS

jayanttibhe — Tue, 03 Jul 2018 18:57:54 GMT

Hi,

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

Try this ::

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

sakshikaul — Tue, 03 Jul 2018 19:06:24 GMT

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 — Tue, 03 Jul 2018 19:12:29 GMT

Sample QVW please.

qlikviewwizard — Wed, 04 Jul 2018 03:44:28 GMT

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