Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
chriscools
Creator II
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
































































SkuCodeSkuNLopen
  bestellingen
stock Mechelenstock KontichMechelen genoeg?
26284469009514397427251
Q201WRKaars wildroos
  D2.2H25
244800-2448
Q201FRKaars framboos
  D2.2H25
229200-2292
Q240NKaars 3 wieken zwart
  D12cm
214200-2142
13555Zak van 6 veders
  elastic
187380-1865
Q214PKaars bol pruim D6cm1764120-1752
Q214OKaars bol oranje D6cm163200-1632
1 Solution

Accepted Solutions
Gysbert_Wassenaar

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

View solution in original post

5 Replies
jvitantonio
Luminary Alumni
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.-

chriscools
Creator II
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

jvitantonio
Luminary Alumni
Luminary Alumni

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

Gysbert_Wassenaar

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

View solution in original post

chriscools
Creator II
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