Date format question

[#1]

Hello everyone,

I have a quick question. I don't know if it's exactly possible, but can I show a value in QV throughout the month if in the Excel file the value is set to a specific day?

In the Excel file, near the target for January I have the date 01.01.2010, but the target should apply for the whole month. If in QV I select January 02 it doesn't show me anything, and that's normal. What I would like to know is if I can set the value to the month of January according to only the month and year of the date in Excel and disregard the day. Is it something that I can do in the load script or is it a function I can use later on? I have the same problem trying to do this for a year period. Target is set to 01.01.2010 and even though it applies for the whole year, if I click on February it's not shown anymore.

For this project I can also modify the value in the Excel file. How should I list the date there so that QV can get the info accordingly?

Does it make any sense?

Bogdan

[#2]

No problem.

I read that you were still working on the table with the monthly targets.

If you add them, and the field is also called target, I have to be carefull not to make a total of the yearly and the monthly target.

But I think that a yearly target should be the sum of the monthly targets, so if you ahve the monthly gigures, you could leave the yearly targets out of the excel.

regards,

and good luck and fun with qlikview in the future.

Yves

[#3]

Thanks for the tip Indeed it's easier to set monthly targets and just tell QV to add them afterwards. In case i run into anymore trouble that I cannot solve on my own, you'll find my questions here

Thank you again,

Bogdan