Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
pandrews87
New Contributor

Show certain expression value in a straight table

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?

1 Solution

Accepted Solutions

Re: Show certain expression value in a straight table

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

6 Replies

Re: Show certain expression value in a straight table

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

pandrews87
New Contributor

Re: Show certain expression value in a straight table

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

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

Community Manager
Community Manager

Re: Show certain expression value in a straight table

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

Sue Macaluso
pandrews87
New Contributor

Re: Show certain expression value in a straight table

Oh sorry, using Qlikview

pandrews87
New Contributor

Re: Show certain expression value in a straight table

Hi Sunny

 

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

 

Paul