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: 
vignesh_s
Creator
Creator

hi

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

1 Solution

Accepted Solutions
PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

9 Replies
prma7799
Master III
Master III

Try like this

before(sum(Price))

Please check this also

Missing Manual - Before() and After()

vignesh_s
Creator
Creator
Author

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

prma7799
Master III
Master III

Please share sample file with sample output

Mark_Little
Luminary
Luminary

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
Creator
Creator
Author

i tried wat usaid, but result is samebfr.png

vignesh_s
Creator
Creator
Author

bfr.png

prma7799
Master III
Master III

Like this??

PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
vignesh_s
Creator
Creator
Author

Thanks my doute got clarified