Between Dates on line chart

[Info4Dan]

Hello,

I have a table with all the dates in 2017, and i wanted to show on the line chart only the dates between 15/06/2020 and 15/07/2020, but am not able to achieve that.

Can anyone help me?

Thanks, 

Dan

[JuanGerardo]

I'm afraid I make a mistake in the expression. I have now created a test app and I realized I didn't use the double quotes 😬.

With a load script for test like the following:

Data:
load Date(RowNo() - 1 + Date('01/01/2020', 'DD/MM/YYYY')) as Código,
Round(Rand() * 1000) as Quantity
AutoGenerate(365);

I have created two linecharts, with two expressions:

Top linechart:
Sum(Quantity)

Bottom linechart:
Sum({<[Código]={">=15/06/2020<=15/07/2020"}>} Quantity)

And you can see the result:

PD.- I have used Sum() instead of Count() as it is easier than count for this test data.

JG

[Info4Dan]

código is the code of each line, so when i count them it should go line by line.

I tried what you used but still shows error, the data on line is a normal date calendar, and i tried both sum and count ..

[Info4Dan]

@JuanGerardo  yeah only got to work with ideas, the filter is nice