Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Displaying avg prices

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

15 Replies
Not applicable
Author

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.

Carlos_Reyes
Partner - Specialist
Partner - Specialist

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.

Not applicable
Author


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

Carlos_Reyes
Partner - Specialist
Partner - Specialist

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.

Not applicable
Author


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

Carlos_Reyes
Partner - Specialist
Partner - Specialist

I'm glad you found a solution.