Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding a value based on RowNo

Hi,

I have a pivot table:

2011-10-13_17-47-57.jpg

The expression for column 1 is:

If(RR2_RowNo=30, Sum(RR_Belopp), Sum(RR_Verksamhetsmål))/1000

But now the customer wants to add the value from column 1, RR2_RowNo 30 (-49 937) to RR2_RowNo10 (270 771+49 937).

Is that possible?

I've tried with:

If(RR2_RowNo=30, Sum(RR_Belopp), If(RR2_RowNo=10, (Sum(RR_Verksamhetsmål)+Sum({$<RR1_RowNo={30}>} RR_Belopp)), RR_Verksamhetsmål))/1000


But that din't help...

Some ideas?

@Ungvall

Senior Business Discovery Manager at Advectas AB

14 Replies
llauses243
Creator III
Creator III

Hi,

This is my offer, pls to see image attached

Good luck, Luis

Not applicable
Author

Hi,

Thanks - but the result should be:

RowNo 10     424 221

RowNo 20     -38 822

RowNo 30     -18 065

Based on your pict.

@Ungvall

Senior Business Discovery Manager at Advectas AB

rbecher
MVP
MVP

Basically we are doing such things on the data level by joining a table with the aggregation logic.

- Ralf

Astrato.io Head of R&D
s_uhlig
Partner - Creator
Partner - Creator

Hi,

May be you miss to total your sum

If(RR2_RowNo=30, 

     Sum(RR_Belopp) ,

     If(RR2_RowNo=10,

          Sum(RR_Verksamhetsmål)+Sum({<RR2_RowNo={30}>} total RR_Belopp),

          Sum(RR_Verksamhetsmål)

     )

)/1000

Regards

Sven

llauses243
Creator III
Creator III

Hi,

This is my offer, pls to see image attached

Good luck, Luis