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]

Hi @Info4Dan, you can limit the measure expression with set analysis to show data only between those dates. For example:

Sum({<MyDate={>=$(=Date('15/06/2020', 'DD/MM/YYYY')<=$(=Date('15/07/2020', 'DD/MM/YYYY')}>} Sales)

JG

[AshutoshBhumkar]

Hi,

As you only have dates for 2017, you need to create Master Calendar from min date of you data till 15/07/2020 . 

Refer below post for Master calendar and configure the min, max values as per your requirement.

https://community.qlik.com/t5/QlikView-App-Dev/How-to-Create-Master-Calendar/td-p/103109

Then you can write set analysis as mentioned by @JuanGerardo 

Thanks,

Ashutosh

[Info4Dan]

Pardon my ignorance @JuanGerardo , but where do i input this analysis on the chart?

[JuanGerardo · Accepted solution]

In the linechart expression, as your measure expression:

JG

[Info4Dan]

oh i got the calendar and all dates, but on the graphic visualization, should i put the analysis on dimension? or as a measure? i have the date as dimension and count of codes(quantity) as the measure to show the number of codes per day. where should i add this analysis to filter my graph?

[Info4Dan]

and thanks and really sorry for dumb questions

[JuanGerardo · Accepted solution]

No dumb questions, just sometimes dumb answers 😉

You should put in measure, something like:

Count({<MyDate={>=$(=Date('15/06/2020', 'DD/MM/YYYY')<=$(=Date('15/07/2020', 'DD/MM/YYYY')}>} Quantity)

JG

[Info4Dan]

i think if i show you it will be better(im really noob at qlik, been using pbi and tableau)

so the below graphics i did using the ideas, and that's what i want, but i wanted to do it normally,

data publicação is the date column, and 'código' is the colum with distinct values to be able to count them and show how many news appeared in the time range

i set the measure and it didnt work

thanks for the patience,

Dan

[Info4Dan]

Count({<[Código]={>=$(=Date('15/06/2020', 'DD/MM/YYYY')<=$(=Date('15/07/2020', 'DD/MM/YYYY')}>} Quantity)

i used this