topic Re: Re: Put a value in another row in QlikView

Put a value in another row

pgalvezt — Wed, 20 Nov 2013 21:23:28 GMT

Hello,

I have a Pivot with dimensions: Group, Account SubAccount so on.

My exp are

Ene= Sum(Amount_01)

Feb=Sum(Amount_02)

So on until Sept

In the 5th row of my pivot I have a Value that I don´t want it. so I created: for March for example:

Sum({<Account={'32010310'},SubAccount-={'AR-01','AR-02'},Account-={'32010310'}>}Amount_03)

So the value is gone. But...

I want that this value be moved to the 9th row and calculated within others values.

How can I do that?

Thanks!

Re: Put a value in another row

Josh_Good — Wed, 20 Nov 2013 21:30:47 GMT

Could you post a sample qvw please.

Re: Re: Put a value in another row

pgalvezt — Thu, 21 Nov 2013 12:41:16 GMT

I have created an Excel File (Simple) with what I want to obtain. Basically I need to change an account value to another row into my pivot. I wnat to move 1591364 to penultimate row. Below 1970218.

Thanks!

Re: Re: Put a value in another row

Josh_Good — Thu, 21 Nov 2013 15:29:05 GMT

What I'm seeing is a sorting issue. Is that correct? You could create a field that defines the sort order you want and then set the sort to look at that field.

Re: Re: Put a value in another row

pgalvezt — Thu, 21 Nov 2013 17:29:08 GMT

I think is not a problem of sorting. I want to move the value (With the same sorting actually) to penultimate row. Can QlikView do that. Is like in excel cut - paste.