topic Calendar for 2 dates in QlikView

Calendar for 2 dates

Tue, 10 May 2011 12:24:38 GMT

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)?

Calendar for 2 dates

Anonymous — Tue, 10 May 2011 13:04:24 GMT

You could do something with the calenders during the LOAD ... like adding the possible dates (start / end) in some linktable.

I did had a simular problem and John Witherspoon gave some good examples for this.

Something else we once used because the LOAD solution was no option there ... use 2 calendars which are not connected to any tables and use the Set Analysis to get the right selection.

This is not really the best thing for the performance ... so I would go with the first solution ... do some pre-loading for the calendar in the LOAD script.

rgrds,

Anita

Calendar for 2 dates

Tue, 10 May 2011 13:24:09 GMT

I can do for your second option, but does not affect, dimensions. I am creating a simplechart table.

only if I put "set analisys" in dimenssões. more so I do not know.

Calendar for 2 dates

Anonymous — Tue, 10 May 2011 13:28:18 GMT

In dimensions this doesn't work ... dimensions with expresions can't handle everything 😉

What you should do is use the set analysis on the expression columns.

When all expression columns contain a null value the total row is not shown (so the dimension is not shown too) ...

This could be done by using e.g. an if expression which only shows the data when having the start and ending date between the selection ... or using a set analysis expression.

Calendar for 2 dates

Tue, 10 May 2011 14:25:21 GMT

Anita,
I'm close to solving this problem but still need help.
did the following: I created a mailbox (v_inidata) and a list with the expression = if (CalendarioDataEnvioAux.Data> = v_dataIni, v_dataIni). then type in the mailbox valueof the variable list and absorbs the value.
Only one problem, after I enter the mailbox have to click on the list to be able to filter through. is to solve this.

Calendar for 2 dates

Anonymous — Tue, 10 May 2011 14:44:16 GMT

I'm not sure if I understand you're message ...

If you have 2 calander fields to choose from ... and you make a selection ...

you should do something like this in the expression:

if( date_from_table >= selectedvalue(start_date) and date_from_table <= selectedvalue(end_date), value_to_show)

the function for selectedvalue is not correctly ... but i just closed the server I work on ... it should be the function to select the value selected for a field ...

Hope this helps ... if not, try posting a sample qlikview so we can help you there.

Calendar for 2 dates

ToniKautto — Tue, 10 May 2011 14:51:39 GMT

Please attach a sample of your QVW file, to make evaluation of your issue easier.

In case your app contains sensitive data, please scramble the fields to make the content unreadable;

Settings > Document Settings > Scrambling

Calendar for 2 dates

Tue, 10 May 2011 15:06:28 GMT

Toni,
How do I attach a qvw?

Calendar for 2 dates

ToniKautto — Tue, 10 May 2011 15:12:46 GMT

1. Select Edit in the bottom right corner of your community entry.

2. You can attach files in the bottom of the editing page.

Re: Calendar for 2 dates

Tue, 10 May 2011 15:25:15 GMT

Ok.

Calendar for 2 dates

Tue, 10 May 2011 18:47:22 GMT

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

Calendar for 2 dates

Anonymous — Thu, 12 May 2011 08:00:19 GMT

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

Re: Calendar for 2 dates

Thu, 12 May 2011 09:05:11 GMT

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

Re: Calendar for 2 dates

Anonymous — Thu, 12 May 2011 09:17:22 GMT

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

Re: Calendar for 2 dates

Thu, 12 May 2011 12:28:29 GMT

Sajeevan,

thank you, little was missing and you solved.

Calendar for 2 dates

ToniKautto — Thu, 12 May 2011 12:39:46 GMT

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

Re: Calendar for 2 dates

Thu, 12 May 2011 12:40:32 GMT

Hi,

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

Best Regards,

Sajeevan

Calendar for 2 dates

Anonymous — Thu, 12 May 2011 12:42:06 GMT

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