topic Show certain expression value in a straight table in QlikView

Show certain expression value in a straight table

pandrews87 — Sat, 16 Nov 2024 20:41:06 GMT

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?

Re: Show certain expression value in a straight table

sunny_talwar — Wed, 12 Jun 2019 11:37:46 GMT

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

Re: Show certain expression value in a straight table

pandrews87 — Wed, 12 Jun 2019 13:27:03 GMT

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 '-'

Re: Show certain expression value in a straight table

sunny_talwar — Wed, 12 Jun 2019 13:28:47 GMT

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

Re: Show certain expression value in a straight table

Sue_Macaluso — Wed, 12 Jun 2019 13:39:25 GMT

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

Re: Show certain expression value in a straight table

pandrews87 — Wed, 12 Jun 2019 14:00:49 GMT

Oh sorry, using Qlikview

Re: Show certain expression value in a straight table

pandrews87 — Wed, 12 Jun 2019 14:20:31 GMT

Hi Sunny

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

Paul