3 Replies Latest reply: Sep 5, 2013 8:48 AM by Stefan Wühl RSS

    How to include dimension in expression but not in table header row?

      productarticlenoweek1week2week3
      A10111532
      B20173148
      C30194124
      DimensionsExpressions

       

      I need to have above table. and its a straight table. Product and ArticleNo are dimensions. Week1, Week2 and Week3 are expressions.

      Now, in qlikview, Product, ArticleNo, Week are dimensions. Product contains product names, ArticleNo contains article names and Week contains week numbers as 1,2,3...

      I need expressions formula for week1, week2, week3. Remember that values in week1,week2,week3 doesnt come from any field. They are calculated as NumericCount(ArticleNo). I have somewhat below formula, but it does not give me correct values. I need help. Thanks in advance.

       

      =aggr(NumericCount(ArticleNo), Product, ArticleNo)