Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use an if statement to only show when the output is N/A
Use an if statement to only show when the output is N/A
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 '-'
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
@pandrews87 Are you using Qlik Sense or View? I would like to move this into the correct product forum.
Oh sorry, using Qlikview
Hi Sunny
No, but will try that and get back to you.
Paul