Select Month and Timestamp

[#1]

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

[#2]

No ideas?

[#3]

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

Gordon

[#4]

Hi Gordon,

heres the QlikVIew File - but without my excel.

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

Thank you.

[#5]

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

[#6]

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?

[#7 · Accepted solution]

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

[#8]

Thanks for your help Gordon.