Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table in which I have to display the PY Prices for each material and month and the PY Price at material level without considering the month. (see the attachment for a good understanding).
The problem is when I calculate the PY Price for each material, it compares only in one cell, but I'd like to repeat the same value for all months.
My formula is
avg(aggr(PY_PRICE,,MG_DESCRIPTION_MG_LEV1, MAT_MATERIAL_CODE)).
How to modify it in order to repeat the value in all the other cells?
Thank you
I'm not using the Section Access.
I've just turned on the Admin Override Security from Document Properties, I don't know if this was the cause, but you can try again.
I still can't open your document. You say everyone has problems with your documents, have you tried to save the app in a different computer and upload it from that computer?
I have no idea of what can cause this problem.
I haven't tried it yet. Could be some settings on the server? Because either my colleague who works on the same machine has the same problem when she tries to upload documents.
I've made a copy on my local and I've tried to uploaded from here. Try now, please!
Thank you very much for your availability.
Cristina
Nope.. I still can't open your document and I don't know what can be hapenning. I think you should ask your QlikView provider why do you have this problem. Perhaps QlikCommunity itself may help... you can open a thread to try to figure out what could be the problem. I remember that in old versions of QlikView there were some settings like security for MACHINE ID... perhaps you're using something like that.
Do you manage the QlikView environment? What kind of security are you using? What version of QlikView?
I'd love to help you resolve this but I don't have the slightest idea of what is causing this problem.
Sorry for not being able to help you.
Hi,
finally it works using the formula
avg( TOTAL <MAT_MATERIAL_CODE>
aggr(
Sum( {$<MONTH_MONTH_OF_YEAR= >} PY_PRICE)
MAT_MATERIAL_CODE)
)
Thank you a lot for your suggestions.
Cristina
I'm glad you found a solution.