topic Re: accumulation based on two dimension in QlikView

accumulation based on two dimension

nizamsha — Mon, 01 Jul 2013 05:05:14 GMT

Hi All

this is my inline table

	Date, Properties, Value
	11/12/12, Fridge, 20
	11/12/12, A/c, 30
	12/12/12, Fridge, 30
	12/12/12, A/c, 40
	12/12/12, TV, 60
	13/12/12, Fridge, 70
	13/12/12, LCD, 40

];

this is the output i want

	Date, Properties, Value result
	11/12/12, Fridge, 20,20
	11/12/12, A/c, 30,30
	12/12/12, Fridge, 30,50
	12/12/12, A/c, 40,70
	12/12/12, TV, 60,60
	13/12/12, Fridge, 70,120
	13/12/12, LCD, 40,40

];

i have attached the qvw file here

Re: accumulation based on two dimension

tresB — Mon, 01 Jul 2013 05:15:10 GMT

Can you please explain the logic of your 'Result' column ?

Re: accumulation based on two dimension

nizamsha — Mon, 01 Jul 2013 05:37:10 GMT

i have a properties field in that i have fridege,ac,tv,lcd

what the logic is in properties i have fridge result is 20 and value also 20..like that i hve ac in properties for that i have result is 30 and value is 30 but in properties again fridge is coming.. but the result is how its coming mean fridge 20+fridge 30= result 50its should sum like that for ac

for me result is coming correctly when i sort the properties ascending or descending but when i sort the date its not coming what i except

Re: accumulation based on two dimension

nizamsha — Mon, 01 Jul 2013 05:50:13 GMT

i am getting the result when i sort the properties ascending or descending but when i sort the date is not coming what i except when i sort date it should display the same like properties

Re: accumulation based on two dimension

tresB — Mon, 01 Jul 2013 05:58:32 GMT

So basically you are looking to sort the table date wise, right? If so, go to sort tab and promote the Date to top.

Thanks.

Re: accumulation based on two dimension

nizamsha — Mon, 01 Jul 2013 06:05:55 GMT

i want to sort date wise and also with properties wise i promote the date to top but its not working

Re: accumulation based on two dimension

nizamsha — Mon, 01 Jul 2013 06:10:22 GMT

hi tresesco

i have attched a qvw kindly look at that

Re: accumulation based on two dimension

tresB — Mon, 01 Jul 2013 06:12:40 GMT

If you want to sort on two dimensions, the first preference is given to the one at top and then to the one which follows.

Re: accumulation based on two dimension

nizamsha — Mon, 01 Jul 2013 06:19:37 GMT

Hi tresesco

its not working i tried it result should be like this

40,70,70,100,120,40,60

even if sort each dimension one by one result should be like above

Re: accumulation based on two dimension

tresB — Mon, 01 Jul 2013 06:33:21 GMT

Hi,

Sorry, I went through your attachment and first post, but completely lost, could not fugure out your actual desired output.

Re: accumulation based on two dimension

nizamsha — Mon, 01 Jul 2013 06:58:42 GMT

i have attached a qvw file

Re: accumulation based on two dimension

nizamsha — Mon, 01 Jul 2013 07:39:02 GMT

finally i got the output