topic Re: set analysis for starting to end date in QlikView

set analysis for starting to end date

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

HI,

I want when user selects the date in calendar then budget(MRP daily target) and sales (Mrp daily achievement) should be displayed.

here i am getting same values for daily sales for period 21/6/2018 to 27/06/2018 which is not correct, please help stalwar1‌

following is the expression for MRP daily target

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

following is the expression for MRP daily achievements

=num(sum({<BugetDate = {">=$(From)<=$(To)"} >}[inv value]/Sales_INR_Unit))

sergio0592 — Sun, 01 Jul 2018 20:07:55 GMT

Hi, try with :

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

=num(sum({<BugetDate = {">=$(=From) <=$(=To)"} >}[inv value]/Sales_INR_Unit))

vishsaggi — Sun, 01 Jul 2018 20:33:36 GMT

CCan you share your app to look into if possible and your expected output values for those expressions?

sakshikaul — Mon, 02 Jul 2018 10:33:46 GMT

This problem was solved by using following expression

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