Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi I have an chart which has null values
QR | Key | Revenue |
01-04-2013 | 0 | 100 |
01-01-2014 | 1 | 200 |
01-02-2014 | 2 | 300 |
01-03-2014 | 3 | 400 |
01-04-2014 | 4 | 500 |
01-01-2015 | 5 | - |
01-02-2015 | 6 | - |
01-03-2015 | 7 | - |
and I want chart like this pls help
QR | Key | R |
01-04-2013 | 0 | 100 |
01-01-2014 | 1 | 200 |
01-02-2014 | 2 | 300 |
01-03-2014 | 3 | 400 |
01-04-2014 | 4 | 500 |
01-01-2015 | 5 | 500 |
01-02-2015 | 6 | 1000 |
01-03-2015 | 7 | 2000 |
Hi
Please provide more information, preferably the source data file and a sample qvw with problem chart.
Regards
Jonathan
here is the attachment
and my result should be like this
QR | Key | R |
01-04-2013 | 0 | 100 |
01-01-2014 | 1 | 200 |
01-02-2014 | 2 | 300 |
01-03-2014 | 3 | 400 |
01-04-2014 | 4 | 500 |
01-01-2015 | 5 | 500 |
01-02-2015 | 6 | 1000 |
01-03-2015 | 7 | 2000 |
Are the values 500, 1000 & 2000 for Revenue coming from your source file?
If possible share the source xls file.
Accumulation is not really making sense ! could you explain the logic, or it is adhoc ?
no it is not coming from source file it is just mulplying doubled its value..
here is my source file
Hi,
after key 4 the revenue should want to double is value
first it should repeat is previous value then it should double as 1000,2000,3000 for null values of revenue
May be like attached sample?
PFA
Thanks but what we want to do if we need this output in front end expression..
hi sara,
try this
if(Key>4,above(column(1))*2,sum(Revenue))