Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

combine different date fields in one master calender

Hi!

I would like that my qlik application is time related.

I am using many tables from my for different sheets,each table has a datefield.

How do I combine all these dates in one calender?

So that I can select 2014 and all my reports built around different datefield use the selected year?

Kind regards,

Katleen

13 Replies
Not applicable
Author

I'm using (Qlikview Components) Qvc.CalendarFromField().

Is there an explanatory manual of some kind for these variables that you say?

Kind regards,

Katleen

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The documentation is in the QvcDocumentation.qvw file. On the Detail tab, select Qvc.Calendar and then Variables in the container. CalendarFromField uses Qvc.Calendar so the Variable doc is actually in Qvc.Calendar. I admit that could use some clarification.

You can also use the language files as documented on the Languages sheet in the Doc.

-Rob

Not applicable
Author

That worked, thank you!

I'am sorry but I keep having troubles

In attachment you can see the stosag_date in a list box.

I used this datefield to create a calendar from field.

But strange enough I get dates starting from 1911 in the calendar and that year doesn't exist in the stosag datefield.

How is this possible?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

It's hard to say without seeing the data, but it looks like you may have some stosag_date values that are not being recognized as dates.

When you select 1911, what date(s) appear in the stosag_date listbox?

-Rob