Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
max31
Contributor III
Contributor III

Ignoring a dimension in a table

Hello all,

I have a similar issue as explained in this post.

If I use to formula from @swuehl  to compute my annual revenues:

 

aggr(rangesum(sum(monthlyRevenues)),year)

 

I end up with this:

YearProductStockAnnual revenue
2016A22858
2017A13-
2017B29837
2018A12-
2018B2-
2018C214753

 

How to fill the blank cells with the annual revenues?

Thanks

Labels (2)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

It is a bit tricky without having a sample to work on.  I suggest you to consider to post a sample qvw or a set of transaction data to your question and even in future questions in the community. If you do you will more likely get a more response to your question. 

In this case it could be a simple fix to your expression. Try this:

aggr(NODISTINCT rangesum(sum(monthlyRevenues)),year)

 

-Vegar 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Frank_Hartmann
Master II
Master II

can u share a sample qvw showing your porblem?

Vegar
MVP
MVP

It is a bit tricky without having a sample to work on.  I suggest you to consider to post a sample qvw or a set of transaction data to your question and even in future questions in the community. If you do you will more likely get a more response to your question. 

In this case it could be a simple fix to your expression. Try this:

aggr(NODISTINCT rangesum(sum(monthlyRevenues)),year)

 

-Vegar 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
max31
Contributor III
Contributor III
Author

Thanks a lot @Vegar  this is what I was looking for!

Usually I would have posted a data sample but I thought this question was simple enough for you to answer.

I guess I was right since you found the solution very quickly 😉