Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Put a value in another row

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!

4 Replies
Highlighted
Employee
Employee

Re: Put a value in another row

Could you post a sample qvw please.

Highlighted
Specialist
Specialist

Re: Re: Put a value in another row

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!

Highlighted
Employee
Employee

Re: Re: Put a value in another row

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.

Highlighted
Specialist
Specialist

Re: Re: Put a value in another row

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.