Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calendar for 2 dates

hello,
I'm more than 1 hour researching a timetable to do the following:
I have two on my dashboard calendar object, where one is to select the start date and end date to another.
to make two objects using search, where at first I was selecting a particular date field or higher and another that would select the same date in another table with only smaller or equal.
Is to do with the calendar object or something that looks like the calendar (I saw some very good examples of John Witherspoon)?

17 Replies
Not applicable
Author

Hi,
not yet have a solution, if someone can help me.

Anonymous
Not applicable
Author

if you use something like this in de expression:

if(CalendarioDataEnvioAux.Data >= v_dataIni and CalendarioDataEnvioAux.Data <= v_dataFim, DATA_TO_SHOW)

Don't know for sure how you use the date selection . . . but if you want a date to be between to other dates this is the way you get a null value for all fields which are not compliant to the if expression. Those rows shall not be displayed in the chart table ...

rgrds,

Anita

Not applicable
Author

Hi,

I am not sure whether I understood your requirement correctly.

What I understand is that you want show the transactions falling between two dates. If this is the case then I think the attached one after some changes is good enough else please let me know.

Best Regards,

Sajeevan

Anonymous
Not applicable
Author

It's nothing more than the if statement in the expression, when null the row is not shown ...

The sample of Sajeevan is exactly like I suggested . . . if this is not working . . . be more specific what date fields you mean . . .

rgrds,

Anita

Not applicable
Author

Sajeevan,

thank you, little was missing and you solved.

ToniKautto
Employee
Employee

Please dont forget to mark the thread as solved if you have found what you where looking for, or tag helpful comments.

Not applicable
Author

Hi,

Most welcome. Please mark it as answered so that others do not spend their time.

Best Regards,

Sajeevan

Anonymous
Not applicable
Author

Great that your problem is solved ... and as the others mentioned . . . tag all helpfull comments 😉