Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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)

3 Replies
MVP
MVP

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

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.

Not applicable

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

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.

MVP
MVP

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

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?

Community Browser