topic Re: before functionality in pivot table in QlikView

before functionality in pivot table

sivarajs — Mon, 22 Jan 2018 11:31:24 GMT

Hi All,

i am using before function in pivot table with 3 dimensions. My expression is as below

if(columnno()=1, Sum(Qty), Before ([inv])) --inv is one of my expression

When i select some values in the dimension am getting proper values as per the expression defined. But without selection am not getting the values proper, giving some random.

How do i get without selection.

Thank you!

-Sivaraj

Re: before functionality in pivot table

sunny_talwar — Mon, 22 Jan 2018 11:32:58 GMT

Would you be able to share an image with and without selection?

Re: before functionality in pivot table

sivarajs — Mon, 22 Jan 2018 12:06:19 GMT

Thank you for your reply

i have just pasted a sample here,

when i select source 165A,

Source		Planmonth	201609	201610	201611	201612	201701	201702
165A	hand		20000	20500	21700	22180	23180	27200
	offset		500	1200	480	1000	4020	-100
	inv		20500	21700	22180	23180	27200	27100

when i dont select somewhere i get right values but not proper

Source		Planmonth	201609	201610	201611	201612	201701	201702
165A	hand		20000	35000	-14000	22180	23180	12000
	offset		500	1200	480	1000	4020	-100
	inv		20500	36200	22180	23180	27200	11900

Re: before functionality in pivot table

sunny_talwar — Mon, 22 Jan 2018 12:55:27 GMT

when i dont select somewhere i get right values but not proper

What do you mean? that the values are right but not proper? What is proper?

Re: before functionality in pivot table

sivarajs — Mon, 22 Jan 2018 13:06:59 GMT

In 2nd table, i have not selected source 165A, for some months am getting before values of inv is correct for some other it's not correct