topic Re: Why an error in calculated dimension? in QlikView

Why an error in calculated dimension?

Wed, 06 Jan 2016 08:43:01 GMT

See attached QVW

Notice this load script, which will implicitly JOIN on the "Top Level Line" column.

LOAD * INLINE [

Top Level Line, Value

Other Income, 10

Revenue, 5

];

LOAD * INLINE [

Top Level Line, Detail Line, DetailValue

Other Income, Misc Income, 1

Other Income, Minor Income, 3

Other Income, Special Income, 6

];

I want to identify Top Level Lines that have some extra detail.

In other words, Top Level Line where COUNT([Detail Line])>0

I've used that expression in 3 places.

As the second dimension (where the first dimension is [Top Level Line]) -- this throws an error
In the Background Color on the first dimension of [Top Level Line] -- this works
In the Expression where the first and only dimension is [Top Level Line] -- this also works

Why does the first use fail?

sunny_talwar — Wed, 06 Jan 2016 10:58:05 GMT

Won't give any error if you use Aggregate function here:

=Aggr(Count([Detail Line]), [Top Level Line])

I think when using it as a dimension you cannot use aggregation such as count, sum, min, max without Aggr() function

Wed, 06 Jan 2016 19:41:39 GMT

Thanks Sunny, I agree with your diagnosis:

I think when using it as a dimension you cannot use aggregation such as count, sum, min, max without Aggr() function

Do you know why that's true?

Or do you know if that's documented somewhere in Qlikview documentation?

Anyone?