Filter to show only 0 values in a table

pandrews87 — Sat, 16 Nov 2024 04:05:22 GMT

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

Re: Filter to show only 0 values in a table

martynova — Sun, 24 Mar 2019 07:42:59 GMT

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

topic Filter to show only 0 values in a table in QlikView

Filter to show only 0 values in a table

Re: Filter to show only 0 values in a table