topic Re: expression to sync with calendar. in QlikView

expression to sync with calendar.

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

first image is of my dashboard

second image is of barchart on store wise and its sync with calendar with expression as =Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}RealisedSale)/100000

third image is of barchart with discount but its expression is =(InvoiceQuantity)*Replace(ETPMRP,'-','')-(RealisedSale) but i dont know how to sync with calendar.

please help me.

thanx

Re: expression to sync with calendar.

Arthur_Fong — Fri, 16 Aug 2019 06:35:43 GMT

Hi,

Does the budget data has date column?

Thanks and regards,

Arthur Fong

Re: expression to sync with calendar.

riishabhz — Fri, 16 Aug 2019 07:57:20 GMT

its fixed now by this expression.

=Sum({<SalesDate={'>=$(=Date(start))<=$(=Date(end))'}>}RealisedSale)/100000