Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have the following data:
date| type | v_1| v_2| v_3| v_4|
2011-07-11|0|258 |18 |149 |4344 |0 |
2011-07-11|14|1264 |411 |620 |2492 |0 |
2011-07-11|28|1974 |677 |934 |5564 |0 |
20011-07-11|56|1083 |642 |660 |2037 |409 |
2011-07-25|0|276 |26 |166 |5149 |0 |
2011-07-25|14|1037 |239 |537 |2946 |0 |
2011-07-25|28|1403 |510 |635 |2237 |0 |
2011-07-25|56|2520 |1369 |1292 |3483 |868 |
type 0 on the 11th is type 14 on the 25
how can i display them as a sequence?
something like this..
v_1_type0(2011-07-11) | v_1_type14(2011-07-25)
in the first column i will have the information from the 11th type 0 v_1
in the second column i will have the information from the 25 type 14 v_1
and so on...
I hope i made myself clear.
Thanks in advance.
Hi,
the expressions could look like
=only({<date={'2011-07-11'}, type={'0'}>} v_1)
resp.
only({<date={'2011-07-25'}, type={'14'}>} v_1)
This would just compare two values next to each other.
See also attached file.
Not sure what you want to say with "and so on..."
Stefan
thanks, i will check it out.
"and so on..."
my file is dynamic and is updated on a daily basis,
so it’s not always be 2011-07-11 and 2011-07-25
I will have additional date that need to be compare and checked.
Thanks a lot for your quick replay.
Ok, you can replace the literals also with other expression / fields.
Please have a look at Set Analysis in the Help for more details.
Regards,
Stefan