topic Re: Calculation Error in Table Chart in QlikView

Calculation Error in Table Chart

jmonroe918 — Wed, 19 Apr 2017 05:14:14 GMT

I am creating a table chart from a spreadsheet load using cross table.

I'm trying to create a Summary listing Sites as a Dimension and several columns by Type. The calculation I am using is as follows:

=sum({<[Type] = {'Material Variance'} >} Data)

This repeats for the other "Types" (Line Scrap, Refurbish, etc). But I am getting "//Error in calculated dimension". I need a total sum of each Type for each Site. The formula does give an amount in the Text Box, but doesn't filter by the Type specificed.

The QVD and Spreadsheet are attached.

Thanks

Re: Calculation Error in Table Chart

Anil_Babu_Samineni — Wed, 19 Apr 2017 05:22:39 GMT

Set analysis won't work in Dimension level. It will work only on expression level

Re: Calculation Error in Table Chart

avinashelite — Wed, 19 Apr 2017 05:24:33 GMT

Try like this

Aggr(sum({<[Type] = {'Material Variance'} >} Data),Dimensions)

Re: Calculation Error in Table Chart

tresB — Wed, 19 Apr 2017 05:25:41 GMT

Are you looking for something like :

If so, take the calculated dimensions to Expression tab.

Re: Calculation Error in Table Chart

jmonroe918 — Wed, 19 Apr 2017 06:02:40 GMT

Anil, thanks so much for the help. It worked perfectly.

Jeff

Re: Calculation Error in Table Chart

jmonroe918 — Wed, 19 Apr 2017 06:04:07 GMT

Thanks Tresesco.

Jeff

Re: Calculation Error in Table Chart

tresB — Wed, 19 Apr 2017 06:08:01 GMT

Anil Babu Samineni wrote:

Set analysis won't work in Dimension level. It will work only on expression level

This is not true.

The same can be done in the dimension level as well, you would just need an aggr() like:

=Aggr(sum({<[Type] = {'Material Variance'} >} Data) , Site)

Re: Calculation Error in Table Chart

Anil_Babu_Samineni — Wed, 19 Apr 2017 06:11:54 GMT

True, I am saying about his way without Aggr function. And then the same way you suggested in the expression that is the same way I've given and followed. Thanks for thought