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

Filter to show only 0 values in a table

Hi Guys

Wonder if you can help me. I am new to Qlik and struggling with something. I have a simple stock table and have three expressions. Expression 1 calculates the stock totals for all items yesterday:

sum({<StockDate = {'$(=Date(today()-1))'}>} BOH)

expression 2 calculates the stock totals today:

sum({<StockDate = {'$(=Date(today()))'}>} BOH)

and the final expression is a simple calculation that works out the difference.

I then want to just show any items that are basically out of stock but cant seem to figure this out.

Thanks

Labels (1)
1 Reply
Highlighted
Contributor II
Contributor II

You could add to all measure if statement^

1. if(value_today - valye_yesterday <=0, value_yesterday)

2. if(value_today - valye_yesterday <=0, value_today)

3. if(value_today - valye_yesterday <=0, value_today - valye_yesterday )

and hide null values in dimension (first row in table have check box on/off null values)

than in table will be only measure with value_today - valye_yesterday <=0