Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
pandrews87
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
martynova
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