Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Looking for Inventory with JUST zero values

Hi guys

Here is another one.

I have an inventory table that looks like this.

You can see that the column called "vCo$t" has some records where the value is missing (zero or null)

         

ProductIDOthersOHvCo$tsCo$tLoadiCo$tDeltaO$MI
3/8-CHANNEL-GY2200$1.17$1.3212%$1.1319%$0.00
4UGR12$41.58$46.7412%$41.5812%$20.79
5/8X17/32-EXT117,500$0.07$0.0812%$0.0712%$0.00
10-39-259113$19.28$0.00-100%$28.90-100%$0.00
10-65-34313-$9.63-$9.531%$0.00
70-1639155$15.05$16.9212%$15.0512%($0.00)
170-90981265$0.23$0.2612%$0.03654%$2.28
170-912112$0.25$0.2812%$0.03717%$0.00
445-144125-$0.00-$0.96-100%$0.00
445-327119-$0.00-$2.46-100%$0.00
447-26118-$0.00-$6.40-100%($0.00)
600-1138612$402.48$610.7852%$401.0152%$601.52
600-1138712$582.16$883.4552%$618.5343%$618.53
600-1140611$53.00$80.4352%$52.2254%$26.11
600-1141124$53.00$80.4352%$56.7240%$26.11
600-1141312$98.43$149.3752%$97.5753%$0.00
1040-02617$1.48$1.6612%$1.4812%$0.00

I want to create a simple table that displays ONLY inventory where the vCo$t is zero or null.

I tried to use {<[vCo$t]={0}>} in the expression field for vCo$t but all it does is show all records and gives them all a null vCo$t

      

ProductIDOHvCo$tsCo$tLoadiCo$tDelta
10-39-25913-$0.00-100%$28.90-100%
SIL-224-$7.426%$7.006%
URE-622-$24.366%$22.0910%
RG-SIG-533-006-150-18007-$39.756%$37.486%
RG-SIG-533-012-35050X370384-$111.706%$105.326%
PANG-PRIMER-QT1-$23.466%$22.126%
SIG-533-006-60X603-$500.046%$471.476%
VITON-411-$78.356%$73.087%
PANGLAG60-5308-$14.326%$19.65-27%
PANG-CEMENT-QT4-$21.976%$20.716%
SIL-420-$13.626%$13.85-2%
RG-SIG-533-006-150-020055-$3.4011%$2.9914%
RG-SIG-533-006-150-120010-$33.0011%$29.7011%
RG-SIG-533-006-300-12002-$35.0111%$24.1345%

HELP!

Also, how do I use {[Field]={exp}>} if i don't have a formula like "Sum" or "Avg"?

Thanks

0 Replies