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

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

Thu, 05 Sep 2013 12:28:17 GMT

product	articleno	week1	week2	week3
A	10	11	15	32
B	20	17	31	48
C	30	19	41	24

Dimensions		Expressions

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)

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

swuehl — Thu, 05 Sep 2013 12:32:18 GMT

Not sure I understand why you want to use expressions for your weeks. Have you considered using a pivot table instead, using 3 dimensions?

If that's not possible, try maybe like this for week1:

=count({<week= {'week1'}>} ArticleNo)

and so forth for the other expressions.

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

Thu, 05 Sep 2013 12:46:46 GMT

I've tried Pivot tables. But I wasn't able to take average of all the weeks with a single average expression. If you could help me to take average in pivot table, then i can adopt it too.

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

swuehl — Thu, 05 Sep 2013 12:48:57 GMT

It seems I somehow missed the point where you required an average expression.

Could you maybe post a small sample app togehter with your expected outcome?