Search found 199 matches

by miorinnovo
Tue Jan 29, 2019 7:23 am
Forum: Programming
Topic: How do I skip lines of code?
Replies: 2
Views: 2554

Re: How do I skip lines of code?

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!
by miorinnovo
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:...
by miorinnovo
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
by miorinnovo
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...
by miorinnovo
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
by miorinnovo
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...
by miorinnovo
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
by miorinnovo
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
by miorinnovo
Wed Dec 12, 2018 12:05 pm
Forum: Programming
Topic: sample question - using series info
Replies: 4
Views: 3365

Re: sample question - using series info

nice
by miorinnovo
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:

Code: Select all

%lastdate = @otod(@ilast(CANADAALLSTARTS))
smpl  {%lastdate}-5  {%lastdate}

by miorinnovo
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!
by miorinnovo
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.
by miorinnovo
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.
by miorinnovo
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.

Go to advanced search