topic Re: Show Data in QlikView

Show Data

pgalvezt — Wed, 05 Oct 2016 19:12:36 GMT

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 1 0.9

b 5 1.3

Output

a 1 5

b 0.9 1.3

Thanks!

Re: Show Data

robert_mika — Wed, 05 Oct 2016 19:15:54 GMT

Try to change Above to Before

Missing Manual - Before() and After()

Re: Show Data

sunny_talwar — Wed, 05 Oct 2016 19:16:06 GMT

Try this out:

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

Re: Show Data

sunny_talwar — Wed, 05 Oct 2016 19:16:37 GMT

And RowNo to ColumnNo