Filter Table object

[BrianDH]

I have a 10 column table with some dimensions and some measures.   Globally I only want to show the rows where the below calculation is = true  .  The below Calculation is one of my measure columns.

I am looking for examples.

if(SUM(B_BH_AMOUNT_ACT +
B_BH_AMOUNT_PAY +
B_BH_AMOUNT_GLA +
B_BH_AMOUNT_GLL +
B_BH_AMOUNT_GLQ +
B_BH_AMOUNT_GLR +
B_BH_AMOUNT_GLE +
B_BH_AMOUNT_OTHER)
>
Sum(B_BH_AMOUNT_ACC), 'true', 'false')

Thanks

[lorenzoconforti]

If data is not sensitive, you can export the app 

https://help.qlik.com/en-US/sense/June2019/Subsystems/ManagementConsole/Content/Sense_QMC/export-app...

when you say not showing null/zeros, what do you mean? can you please take another snapshot and clarify what you are trying to obtain?

[Kushal_Chawda]

may be you need to individually do sum for all amount in the expression in Calculated dimension 'Oper Unit'

aggr(if(SUM(B_BH_AMOUNT_ACT) +
sum(B_BH_AMOUNT_GLA) +
sum(B_BH_AMOUNT_GLL)+
sum(B_BH_AMOUNT_GLQ) +
sum(B_BH_AMOUNT_GLR )+
sum(B_BH_AMOUNT_GLE) +
sum(B_BH_AMOUNT_PAY) +
sum(B_BH_AMOUNT_OTHER) >
Sum(B_BH_AMOUNT_BUD),[Oper Unit], null()),[Oper Unit])

[BrianDH]

if (SUM(B_BH_AMOUNT_ACT +B_BH_AMOUNT_GLA +B_BH_AMOUNT_GLL +B_BH_AMOUNT_GLQ +B_BH_AMOUNT_GLR +B_BH_AMOUNT_GLE +B_BH_AMOUNT_PAY +B_BH_AMOUNT_OTHER) >Sum(B_BH_AMOUNT_BUD), 1, 0)

Only show if = 1

Should I do this in data handling? 

[lorenzoconforti]

Do you mean in the load script? If you do it in there you will lose the aggregation by your dimensions (i.e. the sum function)

[BrianDH]

Add-Ons

Data Handling 

Function

On the right hand side under Sort

[lorenzoconforti]

No, as that applies to the whole chart

[BrianDH]

Oh, ok, well I do want all the data on this page only to show if my flag is True.

[lorenzoconforti]

Is the condition applying only once to the whole table or row by row?

In your initial post you wrote "Globally I only want to show the rows where the below calculation is = true" which suggests you evaluate the condition by row

If you apply to the whole table, qlik sense will calculate the aggregation for the whole set and either display the table or not, it will not make an assessment on a row by row level

If you can't share the app, it would be worth sharing an excel file with some test data and a table with formulas where you show exactly what you are trying to achieve

[BrianDH]

Everything in the table, it should only show records that have exceeded the budget.

[BrianDH]

At the moment I am working in SQL Developer to validate my data against what the user shows me in her Excel Doc.

Then I will go back to Qlik.  But yes this will be row by row.