# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
Creator II

## how to hide records in table depending on values calculated

Hello,

i have a tabel graph-table where i want to hide every row where "Stock Kontich" is zero and "Mechelen genoeg" has a negative number.

What would be the best way to do this?

thanx!

chris

 SkuCode SkuNL open  bestellingen stock Mechelen stock Kontich Mechelen genoeg? 262844 690095 14397 427251 Q201WR Kaars wildroos  D2.2H25 2448 0 0 -2448 Q201FR Kaars framboos  D2.2H25 2292 0 0 -2292 Q240N Kaars 3 wieken zwart  D12cm 2142 0 0 -2142 13555 Zak van 6 veders  elastic 1873 8 0 -1865 Q214P Kaars bol pruim D6cm 1764 12 0 -1752 Q214O Kaars bol oranje D6cm 1632 0 0 -1632
1 Solution

Accepted Solutions

if [Stock Kontich] and [Mechelen genoeg?] aren't fields but expressions you need to figure out how to aggregate the calculations over the other dimensions using the aggr function. See attached example.

talk is cheap, supply exceeds demand
5 Replies
Luminary Alumni

Hi, on each expression you need to write:

IF(SUM([stock Kontich])<>0, SUM([stock Kontich]))

And do the same for the other experssion.

I hope this help.-

Creator II
Author

Hello,

this helps me in the sence that it only shows the calculation if it is not zero, but it doesn't hide the line.

i would think that i could hide it by suppresiing the null values?

and if use the calculated dimension it gives me "error in calculation" in the column of the calculated dimension.

any idea's?

chris

Luminary Alumni

Sorry I might not understand the problem, but this should help you. Check out the application attached.

if [Stock Kontich] and [Mechelen genoeg?] aren't fields but expressions you need to figure out how to aggregate the calculations over the other dimensions using the aggr function. See attached example.

talk is cheap, supply exceeds demand
Creator II
Author

Hello,

thanx, your example helped me a lot!

i think i had to do it with the calculated dimension because i think with the other solution i could not manage if i have 4 calculated columns  and i want to exclude records based on only the null values in 2 columns.

grtz,

chris

Community Browser