topic chart expression in QlikView

chart expression

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

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?

Re: chart expression

qlikviewwizard — Tue, 03 Jul 2018 09:11:04 GMT

Can you attach the sample data and expected result?

Re: chart expression

sakshikaul — Tue, 03 Jul 2018 09:20:35 GMT

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?

Re: chart expression

sakshikaul — Tue, 03 Jul 2018 09:25:56 GMT

stalwar1‌ Please help

Re: chart expression

Anil_Babu_Samineni — Tue, 03 Jul 2018 11:51:25 GMT

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

Re: chart expression

qlikviewwizard — Tue, 03 Jul 2018 13:49:14 GMT

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