topic Re: hi in QlikView

hi

vignesh_s — Wed, 25 Nov 2020 16:16:04 GMT

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

prma7799 — Wed, 29 Nov 2017 10:55:18 GMT

Try like this

before(sum(Price))

Please check this also

vignesh_s — Wed, 29 Nov 2017 11:14:11 GMT

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

prma7799 — Wed, 29 Nov 2017 11:18:09 GMT

Please share sample file with sample output

Mark_Little — Wed, 29 Nov 2017 11:26:39 GMT

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 — Wed, 29 Nov 2017 12:01:04 GMT

i tried wat usaid, but result is same

vignesh_s — Wed, 29 Nov 2017 12:01:29 GMT

prma7799 — Wed, 29 Nov 2017 12:13:34 GMT

Like this??

PrashantSangle — Wed, 29 Nov 2017 12:21:06 GMT

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,

vignesh_s — Wed, 29 Nov 2017 12:32:01 GMT

Thanks my doute got clarified