topic Re: Creating Monthly Average based on the Item Names in QlikView

Creating Monthly Average based on the Item Names

Mon, 10 Nov 2014 22:10:43 GMT

I have a monthly average variable and I am wanting to put that into my straight table chart.

The field shows up when I put it in the expression with the correct monthly average for a total of all my item names BUT I want the monthly average to calculate based on the individual names and not adding all the items to get the total monthly average.

Re: Creating Monthly Average based on the Item Names

MarcoWedel — Mon, 10 Nov 2014 22:34:37 GMT

please post sample data and required result to clarify your request.

thanks

regards

Marco

Re: Creating Monthly Average based on the Item Names

danieloberbilli — Mon, 10 Nov 2014 22:34:55 GMT

I guess the expression in your variable contains a '=' like vVariable = '=Avg(Field)' try tpo remove the '=' -> vVariable ='Avg(Field)'

Re: Creating Monthly Average based on the Item Names

Mon, 10 Nov 2014 22:44:00 GMT

Below is what it looks like now when I select the InventoryCD. for the monthly average.

What I want it to look like is...As you can see here when I select one InventoryCD I get the Monthly Average of 126. What I am wanting in the image above is to see that 126 instead of the 2271000 on the line for the item 1070SP.

Below is what my Monthly Average variable looks like currently.

Re: Creating Monthly Average based on the Item Names

Tue, 11 Nov 2014 14:11:14 GMT

Below is what it looks like now when I select the InventoryCD. for the monthly average.

Below is what my Monthly Average variable looks like currently.

Re: Creating Monthly Average based on the Item Names

Tue, 11 Nov 2014 20:00:47 GMT

When I remove the = sign this ends up showing no data.