topic Select Month and Timestamp in QlikView

Select Month and Timestamp

Tue, 09 Nov 2010 14:03:03 GMT

Hello,

I need help with matching two tables related to the current date (today).
Please see the attached Timestamp.rar (download it in the link above), which contains the Timestamp.qvw.

In it you can find 3 tables and one Button. When you click on the button QV selects the actual month.
Now I want, that also the Timestamp will be selected, when clicking on the Proof Button.

For example:
When QlikView selects May - in Timestamp there should be selected ALWAYS actual and for May the 1 FC Target
When selecting June - in Timestamp there should be selected actual and for June the 2 FC
When selecting July - in Timestamp there should be selected actual and for July the 3 FC
When selecting August - in Timestamp there should be selected actual and for Augsut 4 FC
When selecting Septemeber - in Timestamp there should be selected actual and for September 5 FC
... and last When selecting October - in Timestamp there should be selected actual and for October 6 FC

In November it starts again - selecting actual and 1 FC Target
December - selecting actual and 2 FC
...
April - selecting actual and 6 FC

How is this achivable?
I cant get it to work.

Thanks in advance,
Regards,
Andreas

Here is the file:
http://www.easy-share.com/1912908814/Timestamp.rar

Select Month and Timestamp

Wed, 10 Nov 2010 10:50:08 GMT

No ideas?

Select Month and Timestamp

Wed, 10 Nov 2010 11:56:04 GMT

Can you attach the file with your posting rather than use easy-share?

Gordon

Select Month and Timestamp

Wed, 10 Nov 2010 11:59:25 GMT

Hi Gordon,

heres the QlikVIew File - but without my excel.

But I dont think you need it - its only one little table.

Thank you.

Select Month and Timestamp

Wed, 10 Nov 2010 12:57:16 GMT

I dont know your data sources but can you not create a table in the load to join Timestamp/Month so that selections are linked within Qlikview?

For example here is a part of what Timstamp.xls would look like:

Timestamp	Month
5 FC	3
5 FC	9
6 FC	4
6 FC	10
actual	1
actual	2
actual	3
actual	4
actual	5
actual	6
actual	7
actual	8
actual	9
actual	10
actual	11
actual	12

Regards,

Gordon

Select Month and Timestamp

Wed, 10 Nov 2010 13:27:43 GMT

Hi Gordon,

good idea, but then i get loops with my other datasources.
The fields month and timestamp are already available.

Any other idea how to achieve that?

Select Month and Timestamp

Wed, 10 Nov 2010 14:01:50 GMT

If you really cant change your table structures I think the only way to go is a macro. You might have been able to change the name of the new column in Timestamp.xls from 'Month' to 'MonthX' and then add another action in the button to set field 'MonthX' to '=Month' but as they fire together then the set field of 'Month' will not have been actioned yet 😞

Regards,

Gordon

Select Month and Timestamp

Thu, 11 Nov 2010 10:47:35 GMT

Thanks for your help Gordon.