Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (5)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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
Highlighted
Master II
Master II

can u share a sample qvw showing your porblem?

Highlighted
Partner
Partner

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

Highlighted
Contributor III
Contributor III

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 😉