Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
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
Highlighted

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

View solution in original post

6 Replies
Highlighted

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

View solution in original post

Highlighted
Contributor
Contributor

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

Highlighted

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

Highlighted
Community Manager
Community Manager

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

Sue Macaluso
Highlighted
Contributor
Contributor

Oh sorry, using Qlikview

Highlighted
Contributor
Contributor

Hi Sunny

 

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

 

Paul