Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Why does the first use fail?
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
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
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?