Change column data based on data from another column in QTableView?

[adutzu89]

So I have a QTableView, QSqlQueryModel as its model, what I want is to set up the data displayed in column Y inside that table based on data from column X.

Below is the code I have for changing the data of the column based on it's own data:

QVariant ModelLProd::data(const QModelIndex &index, int role) const
{
    QVariant value = QSqlQueryModel::data(index, role);
    if (value.isValid() && role == Qt::DisplayRole) {
        if (index.column() == 8 && value==99){
        return value.toString().replace("99","0");
    }
    return value;
}

QVariant ModelLProd::data(const QModelIndex &index, int role) const
{
    QVariant value = QSqlQueryModel::data(index, role);
    if (value.isValid() && role == Qt::DisplayRole) {
        if (index.column() == 8 && value==99){
        return value.toString().replace("99","0");
    }
    return value;
}

To copy to clipboard, switch view to plain text mode 

So basically in index.column()==8 I have percentages and if the value==99 I want to go to index.column()==9 and return value.toString().replace("99","0")

Any ideeas? As I ran out of them.

[anda_skoa]

If you want to alter the value of column 9, then you have to check for request for column 9.
You are currently working solely within column 8

Cheers,
_

[adutzu89]

Can you be more specific about it?
If I put

if (index.column() == 8 && value==99){
                       if(index.column()==9){
                             return value.toString().replace("99","0");
                      }        
        }

if (index.column() == 8 && value==99){
                       if(index.column()==9){
                             return value.toString().replace("99","0");
                      }        
        }

To copy to clipboard, switch view to plain text mode 

,for example, nothing happens and I ran of ideeas how to target column 9 from inside column 8 block.
I understand how to target them normally by checking if index.column matches the column I want, but I can't figure it out how connect those 2 columns.

[anda_skoa]

Well, index.column() can obviously not be 8 and 9 at the same time, so first checking for 8 and the checking for 9 will always fail.

Just imagine what the view will do when it wants to get the value of column 9 in, lets say the first row.
It will call data() with an index that contains row=0 and column=9, right?

So checking for 8 is not going to help you in any way, right?

So you now have the value for row 0, column 9. You want to return that value or a changed value depending on the value in column 8.
How do you get the value of column 8, same row?

Cheers,
_

[adutzu89]

Thank you for your guiding. I finally solved with the following:

QVariant ModelLProd::data(const QModelIndex &index, int role) const
{
    QVariant value = QSqlQueryModel::data(index, role);
    if (value.isValid() && role == Qt::DisplayRole && index.column() == 9) {
        int rand=index.row();
        int val=index.sibling(rand,8).data().toInt();
        if(val==99){
            return value.toString().replace(value.toString(),"0.00");
        }
    }
    return value;
}

QVariant ModelLProd::data(const QModelIndex &index, int role) const
{
    QVariant value = QSqlQueryModel::data(index, role);
    if (value.isValid() && role == Qt::DisplayRole && index.column() == 9) {
        int rand=index.row();
        int val=index.sibling(rand,8).data().toInt();
        if(val==99){
            return value.toString().replace(value.toString(),"0.00");
        }
    }
    return value;
}

To copy to clipboard, switch view to plain text mode 

I was looking at the issue the wrong way.