topic Re: peek or pervious when simular number in App Development

peek or pervious when simular number

joeybird — Tue, 19 Jul 2016 11:19:49 GMT

I am trying to see if next number is lower than the next...but I am having issues when it sees the first number or next

I have tried both expressions

if((Sales)< peek(sales),'1','0') as flag

if((Sales)< previous(sales),'1','0') as flag

basically

Month 1 , sales = 10 ...flag = 1

Month 2, sales = 9.8 ... flag = 1

Month 3, sales = 9.9 ....flag = 0

Month 4 Sales = 9.9 ... flag = 0

Month 5 Sales = 15 .... flag = 0

how can I make Month 1 flag be 0?

please help

Re: peek or pervious when simular number

jonathandienst — Tue, 19 Jul 2016 11:24:45 GMT

Is the field Sales or sales - QV field names are case sensitive.

The correct syntax would be:

If(Sales < Alt(previous(Sales), 0), 1, 0) as flag,

Re: peek or pervious when simular number

Anonymous — Tue, 19 Jul 2016 11:37:32 GMT

Please find the attachement of QVF of your requirement ..

Note : I am assuming 'Sales' as field name ...

Re: peek or pervious when simular number

joeybird — Tue, 19 Jul 2016 12:39:40 GMT

I have tried both and both give me same answer I have been getting

any other ideas please?

Re: peek or pervious when simular number

Mark_Little — Tue, 19 Jul 2016 13:39:12 GMT

HI,

You need to make sure you data is orders by the month,

Then you Can do something like

IF(RowNo() = 1,

IF(Sales < previous(Sales),

)

) as flag,

If you have multiple years you can add a check for year in a similar fashion

Mark

Re: peek or pervious when simular number

ramoncova06 — Tue, 19 Jul 2016 13:47:14 GMT

are your months strings or numbers ?

if they are string, then try adding a number and apply the sort on a descending way, peek or previous should work as long as you use the same field name, like Jonathan already suggested

Re: peek or pervious when simular number

joeybird — Tue, 19 Jul 2016 15:08:49 GMT

Hi guys

still a problem,

I am loading in from SQL tables

I have tried order by month too

I have even tried

Num(replace(Sales, ' ', '')) as Sales... to make sure it sees a number field

I am guessing its rounding the figure? because its decimal places?

please help

Re: peek or pervious when simular number

joeybird — Wed, 20 Jul 2016 08:58:14 GMT

after some testing ..it only works, if field is cast as an int ...not numeric

thanks guys for your help x