This is my first of many posts as this is my first time using QV. A bit of background, I have absolutely no experience in programming and code. I've used excel extensively except for VB but that is about it [:)]
Ok, so I decided to do all the online courses to help prep me for the future ahead. I'm on the Course - Build your first QlikView 9 Application lesson 3 and already encountered an issue. In the previous lesson we had to edit our data to include a Year and Month list from the customer date. I did exactly as they asked and when i include the items in my properties box the list box comes up EMPTY. It does not show me year or month as it does in the tutorial. I have double-checked everything and my script is identical. Any help would be much appreciated
This actually worked LOL 🙂 Guess the date format for my country in the set default values is different to that to what appears in the comma delimited data text file. Changing the set value to read
Set Dateformat = 'DD/MM/YYY'; instead of 'YYYY/MM/DD' gave me what I needed.
@ SE, thanks for your post, but that didn't work; Think I've come a bit closer now with the formatting though. I have however now run into another rather annoying problem. The line chart I have with the year as the Y axis will not sort in order. No matter what I do by sort by y-axis ascending, descending et cetera does not work. I also have a '-' appearing on the axis that looks like an accumulation of the 3 years amounts for some reason.
Hmmmm I think my date format is somehow affecting this. Could I ask for you guys to please download the data for that tutorial, and have at look at the SALESDATE.txt file and let me know if there is something in there that can be causing this.
I have also made a comment about the tutorial and asked them to review these tutorials as certain aspects are not generic for all countries. Thanks though to everyone for your assistance so far, much appreciated
Is there anyway I can attach my QVW file so that you guys can view for yourself?
