2 Replies Latest reply: Jan 6, 2016 2:41 PM by Nathaniel Anderson RSS

    Why an error in calculated dimension?

    Nathaniel Anderson

      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.

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

       

      Why does the first use fail?