Show certain expression value in a straight table

[pandrews87]

Hi All

Wonder could someone help me. I have a straight table with several dimensions and few expressions that shows me if stock has been out since yesterday. 1st expression show me the stock balance as of yesterday and the 2nd expression shows me the stock balance from today. 3rd one is simple calculation between the two. So if stock yesterday >0 and stock today =0 it states "Stock out" if not it shows "N/A". Is there a way that i can filter out all N/A values in my table?

[sunny_talwar · Accepted solution]

Use an if statement to only show when the output is N/A

[pandrews87]

Hi Sunny

Thanks for getting back to me so quick. Struggling with the IF statement.

=if(Sum({<StDate = {"$(=Date(max(StDate)-1))"}>} BOH = 0) and Sum({<StDate = {"$(=Date(max(StDate)))"}>} BOH >0),'Stock In Since Yesterday')

I have then selected suppress missing but just shows all other rows as '-'

[sunny_talwar]

Is this the only expression? If not, then have you applied the same if statement to all the expressions to make sure that they result to null or 0

[Sue_Macaluso]

@pandrews87 Are you using Qlik Sense or View? I would like to move this into the correct product forum. 

[pandrews87]

Oh sorry, using Qlikview

[pandrews87]

Hi Sunny

No, but will try that and get back to you.

Paul