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