topic Re: calculated dimensions in QlikView

calculated dimensions

Wed, 11 Nov 2015 17:11:45 GMT

I have a dimension named [Number Sold]. I have a variable vNumberSold, which is the sum of [Number Sold]. I would like to use this as a calcualted dimension, with different break points/groupings.I have tried using Class function and aggregate functions but ahve not been able to get it to work

when this same field is used in an expression (either sum [Number Sold) or =$(vNumberSold) I get the results I am expecting

part of the issue is if aggr function is needed, the filed to aggregate over - I have tried the highest level and the lowest without any luck

thanks

Re: calculated dimensions

Gysbert_Wassenaar — Fri, 13 Nov 2015 12:19:50 GMT

Can you post a small qlikview document that explains what you're trying to do?

Re: calculated dimensions

Fri, 13 Nov 2015 13:47:41 GMT

Gysbert

Thanks for your follow-up

the last chart is an example showing what the end user is looking for (they provided this to me).

The X axis needs to be a calculated dimesnion based on accumualted tons. The Y axis is an expression (which is used throughout the application) for price/ton.

I was able to do this with the Axis' reversed, but when I switched my calcualted dimesnion to the expression and the expression to the calculated dimesnion I did not get my expected results - the example below is correct with price/ton on x axis and total tons on Y

I will try and post a small application later in the day

thanks again for your help

Re: calculated dimensions

Fri, 20 Nov 2015 14:31:28 GMT

Gysbert

Sorry for the delay, have been out of town most of the week.

Attached is a slimmed down version of the aaplication. I would like to make the dimesnion the expression and the expression the dimension - see sample below. I have tried just swithing and that did not work, and we cannot just rotate the axis (not what the user wants.

Re: calculated dimensions

Gysbert_Wassenaar — Fri, 20 Nov 2015 17:41:49 GMT

You'll have to draw me a picture of the result you want to see. I can't imagine anything else then what you'd get if you change the orientation on the Style tab. If you expect one dimension value to return two expression values with only one expression then that will not happen. This universe does not allow that.

Re: calculated dimensions

Fri, 20 Nov 2015 17:43:14 GMT

ok - give me a few minutes and I will have something for you

Re: calculated dimensions

Fri, 20 Nov 2015 19:30:00 GMT

Gysbert

attached is a document where I did my best to describe what they are looking for

if I try and and aggregate in a calcualted dimension, I have to aggregate over something and whatever I have tried does not give me overall totals

thanks for all of your help so far