topic calculated Dimension in QlikView

calculated Dimension

samuel_brierley — Tue, 15 Apr 2014 08:40:33 GMT

Hi can anyone see why this would evaluate to there are no numeric value on the X axis?

Avg({$< Name = {'MainCarriagewayDataFilteringOutput.site2.o'}>} Value)

value is obviously a number.

I have tried using this formula as an expression and its fine

Re: calculated Dimension

manideep78 — Tue, 15 Apr 2014 08:46:41 GMT

If you want to specify aggregation functions in calculated dimension then you should have to give aggregator....

Try like this:

Aggr(Avg(YourAverageField),YourAggregatorField)

Re: calculated Dimension

samuel_brierley — Tue, 15 Apr 2014 08:49:10 GMT

Hi all.

I think I know the issue but im unsure how to fix it.

the way that my data is arranged is as such

'Time'	'Type'	'Name'	'Value'
00:00		'MainCarriagewayDataFilteringOutput.site2.o'	1
00:00		'MainCarriagewayDataFilteringOutput.site2.q'	2
00:01		'MainCarriagewayDataFilteringOutput.site2.o'	3
00:01		'MainCarriagewayDataFilteringOutput.site2.q'	4
00:02		'MainCarriagewayDataFilteringOutput.site2.o'
00:02		'MainCarriagewayDataFilteringOutput.site2.q'
		'MainCarriagewayDataFilteringOutput.site2.o'

so what i want essentially is at time 00:00 I want a point on the table with 'MainCarriagewayDataFilteringOutput.site2.o' as the dimension and 'MainCarriagewayDataFilteringOutput.site2.q' as the expression.

Im not sure how to tackle this, thanks for any help

Re: calculated Dimension

Tue, 15 Apr 2014 09:55:29 GMT

Why you try with calculated dimension? Maybe you need it as expression?