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: 
pgalvezt
Specialist
Specialist

Show Data

Hello,

I have a table where I am showing cumulative data. (Pivot Table) I need to show the same table but horizontally. When I try to pivot the table data dissapear.

My formula Expressions are:

rangesum(above( Num(sum(VENTAS),'#.##0')/Divisor,0,rowno(total)))    (Sales)

rangesum(above( Num(Sum(VENTAS),'$ #.##0;-$ #.##0')/Divisor,0,rowno(total)))/Num(Sum(TOTAL VENTAS),'$ #.##0;-$ #.##0')/Divisor  (%)

Input

A

a  1  0.9

b  5  1.3

Output

A

a 1      5

b 0.9  1.3

Thanks!

1 Solution

Accepted Solutions
sunny_talwar

Try this out:

RangeSum(Before(Sum(VENTAS)/Divisor, 0, ColumnNo(TOTAL)))

View solution in original post

3 Replies
robert_mika
Master III
Master III

Try to change Above to Before

Missing Manual - Before() and After()

sunny_talwar

Try this out:

RangeSum(Before(Sum(VENTAS)/Divisor, 0, ColumnNo(TOTAL)))

sunny_talwar

And RowNo to ColumnNo