topic Re: Line chart between two dates in QlikView

Line chart between two dates

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

Hy guys.

I would like to create a line chart for a KPI that shows values between two dates.
Those dates are the first day of the month selected and the selected date.

I have tried something like this but it didn`t work

Sum({<DATE={">=$(vMonthStartCS)<=DATE"}>}VALUE/Divider)

vMonthStartCS = date(monthstart(date(DATE,'DD-MM-YY')),'DD-MM-YY')

Do you have other suggestions?

Please help.

Thank you

Re: Line chart between two dates

sunny_talwar — Fri, 14 Jul 2017 13:12:06 GMT

Try this

Sum({<DATE={"$(='>=' & Date(MonthStart(Max(DATE)), 'DD-MM-YY') & '<=' & Date(Max(DATE), 'DD-MM-YY'))"}>} VALUE/Divider)

Re: Line chart between two dates

razvan_brais — Mon, 17 Jul 2017 11:15:10 GMT

Thank a lot , this is what I needed.