Thanks, this gives me an error:
city3 is not defined in "if %city<>city3 then"
edit: it worked once I put city3 in quotes
if %city<>"city3" then
Thanks!
Search found 199 matches
- Tue Jan 29, 2019 7:23 am
- Forum: Programming
- Topic: How do I skip lines of code?
- Replies: 2
- Views: 2554
- Mon Jan 28, 2019 2:50 pm
- Forum: Programming
- Topic: How do I skip lines of code?
- Replies: 2
- Views: 2554
How do I skip lines of code?
I'd like to skip a couple lines of code but can't seem to find a way to program it. SImply put I have 3 variables for 2 different cities and only 2 variables for a third city. I would like to skip the data manipulation code for that third variable when I get to the third city. I am using a for loop:...
- Wed Jan 16, 2019 8:39 am
- Forum: Programming
- Topic: Programming the renaming of multiple variables
- Replies: 1
- Views: 2176
Programming the renaming of multiple variables
Is it possible to import a list of variables in a particular order and then programming them to be renamed in a systematic way rather than have a long list of "rename x y". For example, if I have 100 variables and I want them to be renamed A1,A2...A10,B1,B2,...B10 etc.
Thanks
Thanks
- Thu Dec 20, 2018 8:20 am
- Forum: Programming
- Topic: Can I normalize just one axis on a graph
- Replies: 0
- Views: 1804
Can I normalize just one axis on a graph
Hi, I know how to normalize a graph (n) but how can I normalize one axis of a graph? graph graph.bar(l,d) group This code creates a bar chart on one axis with the first series in group and a line graph on the right axis for the other series. I'd like the bar chart axis to be normalized. Is that poss...
- Fri Dec 14, 2018 6:31 am
- Forum: Programming
- Topic: Programming a colour in every other row of a table
- Replies: 1
- Views: 1926
Programming a colour in every other row of a table
The code below makes the table white form rows 1 to 15. is there a away to only change the colour of every other row?
Code: Select all
table.setfillcolor(1:15) white
- Wed Dec 12, 2018 2:26 pm
- Forum: Programming
- Topic: frequency conversion
- Replies: 1
- Views: 1931
frequency conversion
Can I copy a monthly series into a quarterly page such that the monthly values get averaged over the quarter and when there are months in a quarter that don't have data the last data point is repeated. For example If I have a series Jan=1 Feb=2 March=3 April=4 May=5 Can I get it sod that Q1 is 2 and...
- Wed Dec 12, 2018 2:24 pm
- Forum: General Information and Tips and Tricks
- Topic: Size of graphs
- Replies: 2
- Views: 6203
Re: Size of graphs
damn. thanks anyway
- Wed Dec 12, 2018 1:01 pm
- Forum: General Information and Tips and Tricks
- Topic: Size of graphs
- Replies: 2
- Views: 6203
Size of graphs
I can't seem to figure out how to get graphs to open larger than the standard size right away rather than resizing with the pointer. Is it possible?
Thanks
Thanks
- Wed Dec 12, 2018 12:05 pm
- Forum: Programming
- Topic: sample question - using series info
- Replies: 4
- Views: 3365
- Wed Dec 12, 2018 11:49 am
- Forum: Programming
- Topic: sample question - using series info
- Replies: 4
- Views: 3365
Re: sample question - using series info
Thanks Gareth.
I was looking to use the last date of the sample as the last date in my series. I was able to easily adjust your example to get that though, so for future readers looking how to do this:
I was looking to use the last date of the sample as the last date in my series. I was able to easily adjust your example to get that though, so for future readers looking how to do this:
Code: Select all
%lastdate = @otod(@ilast(CANADAALLSTARTS))
smpl {%lastdate}-5 {%lastdate}
- Wed Dec 12, 2018 10:03 am
- Forum: Programming
- Topic: sample question - using series info
- Replies: 4
- Views: 3365
sample question - using series info
Hi
If I want to have a sample of the last 6 months of my workbook I can use the code:
sample sample1 @last-6 @last
Is there a way to do this with the last date of a series rather than the last date in the workbook?
Thanks!
If I want to have a sample of the last 6 months of my workbook I can use the code:
sample sample1 @last-6 @last
Is there a way to do this with the last date of a series rather than the last date in the workbook?
Thanks!
- Thu Dec 06, 2018 9:45 am
- Forum: Programming
- Topic: Tables that contain series that sometimes aren't populated
- Replies: 8
- Views: 5511
- Thu Dec 06, 2018 9:02 am
- Forum: Programming
- Topic: Tables that contain series that sometimes aren't populated
- Replies: 8
- Views: 5511
Re: Tables that contain series that sometimes aren't populated
Right, this is what I had in mind but I'm not sure how to code an if statement for whether a series exists.
- Thu Dec 06, 2018 8:35 am
- Forum: Programming
- Topic: Tables that contain series that sometimes aren't populated
- Replies: 8
- Views: 5511
Re: Tables that contain series that sometimes aren't populated
The issue is I would rather not have to comment out and uncomment lines of tables all the time. I would like the table code to stay as it is whether all series are populated or only some are populated.
- Thu Dec 06, 2018 8:16 am
- Forum: Programming
- Topic: Tables that contain series that sometimes aren't populated
- Replies: 8
- Views: 5511
Re: Tables that contain series that sometimes aren't populated
Thanks, That would create a second problem though because another formula is dependent on how many series get populated.