Add conditional show in app.visualization.create

[mattias-thalen]

Hi,

I'm trying to populate the table property Add-ons > Data Handling > Calculation Condition & Message when creating a table using app.visualization.create:

app.visualization.create(
    "table",
    columns,
    {
        multiline: { wrapTextInCells: true },
        components: [{
            key: "theme",
            content: { hoverEffect: true },
            scrollbar: { size: "medium" }
        }]
    })

I've successfully done it to the fields using this:

qCalcCondition: { qCond: '=1' }

But I'm unsure how to implement it for the table object.

[mattias-thalen · Accepted solution]

Found the solution by using console.log() and checking the properties of the object created from app.visualization.create()

app.visualization.create(
    "table",
    columns,
    {
        multiline: { wrapTextInCells: true },
        components: [{
            key: "theme",
            content: { hoverEffect: true },
            scrollbar: { size: "medium" }
        }],
        qHyperCubeDef: {
            qCalcCondition: {
                qCond: "=1",
                qMsg: "Condition not met"
            }
        }
    })