Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i'm doing a set analysis below, but i have a problem at &.
someone help??
FLAG_VAL = {'M-' & $(='MaxString({$<PROD={'ACTUAL'}>} SubField(FLAG,'-',2))') }
Thanks,
Hi,
Try with : FLAG_VAL = {'M-$(=MaxString({$<PROD={"ACTUAL"}>} SubField(FLAG,chr(65),2)))' }
Regards,
Vincent
hi two ideas :
1. change to
FLAG_VAL = {"$(='M-' & MaxString({$<PROD={'ACTUAL'}>} SubField(FLAG,'-',2))" }
2. create a variable with this expression:
vFilter = 'M-' & MaxString({$<PROD={'ACTUAL'}>} SubField(FLAG,'-',2))
then in the set analysis write
FLAG_VAL = {"$(vFilter)"}
Vincent, i tried that, it wont work either.
Liron, i tried both methods.. not working too...
can you post a sample data
it's quite difficult...for the data...
the set analysis is part of a bigger formula,
I've done a mistake in my formula, perhaps have you corrected it ? It's not chr(65) but chr(45).
Regards,
Vincent
Vincent,
I tried, 45, but still the same, it's showing 0, at least that's digit.
i also tried to put the doublt qoute around it "chr(45)", it's still the same.
we should be close....
ok, i'm changing the way of calculation.
right now, the set analysis is working in the qvw in attached.
but, there's a need to always select a month, else it wont show any data.
how can i make is show the data without selecting the months?
when the tabel is right, there will only be 2 data for march and april, the rest should be empty.
table on top is just displaying the data for checking. table below is what i'm working on...
hope someone has some solution... thanks
Hi,
I doesn't work because $(=Maxstring(PROD_PLAN_FLAG_REF)) is not executed in the context of your chart but globaly. It means that with no selected month, it does not take in account the current dimension value.
So it returns for each lines M-4 which is only available in january.
Regards,
Vincent