Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
vignesh_s
Contributor

hi

i used 'before' funtion to see hoe it works ,but im geting wrong result, can any help me outpivot.png

Tags (1)
1 Solution

Accepted Solutions

Re: hi

Since you are using Pivot chart but you are not pivoting any column in such case

You can user above() or below() as per your requirement.,

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

9 Replies
prma7799
Honored Contributor III

Re: hi

Try like this

before(sum(Price))

Please check this also

Missing Manual - Before() and After()

vignesh_s
Contributor

Re: hi

i tried sum(price) too but the result is same

prma7799
Honored Contributor III

Re: hi

Please share sample file with sample output

Partner
Partner

Re: hi

Hi,

I think it is down to the way you are testing the function.

The Before function would return the value in the column prior, from the picture you only seem to have one column.

Try expanding you dimensions, have your second dimension along the top. of your table or try the above function.

Mark

vignesh_s
Contributor

Re: hi

i tried wat usaid, but result is samebfr.png

vignesh_s
Contributor

Re: hi

bfr.png

prma7799
Honored Contributor III

Re: hi

Like this??

Re: hi

Since you are using Pivot chart but you are not pivoting any column in such case

You can user above() or below() as per your requirement.,

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

vignesh_s
Contributor

Re: hi

Thanks my doute got clarified