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

How to remove unnecessory values?

Dear All,

My table is like this.

BCOD ORC_CODE REF_NO POL_NO CLA_CODE ORC_COM_DIFF
BA006297BA0014D0028206BA00101A000875MC-0
BA0014D0028209BA00141D0003297MC-0
BA0014D0028218BA00131F001678MC-0
BA0014D0028224BA00071C000841MC-0
BA0014D0028248BA00141X0000270MC0
BA0014D0028250BA00141X0000271MC-77
BA0014D0028251BA00061C000749MC0
BA0014D0028252BA00081F001144MC-0
BA0014D0028270BA00141C0001572MC-413
BA0014D0028275BA00131B002391MC-0
BA0014D0028327BA00141W0000097MC0
BA0014D002833204BA1B000300MC0
BA0014D0028340BA0006HC000026FR189
BA0014D0028346BA00121A001111MC0
BA0014D0028354BA00141X0000285MC-0
BA0014D0028384BA0014SS0000295SS-54
BA0014D0028390BA0011CF001000FR13
BA0014D0028392BA0008TC001454TC90
BA0014D0028430BA00071C000852MC-0
BA0014D0028440BA00141D0003303MC-0
BA0014D0028442BA00081F001147MC1
BA0014D0028449BA00141F0001704MC-0
BA0014D0028456BA0010GT000151MS45
BA0014D0028457BA0008CF000901FR35
BA0014D0028471BA00141C0001578MC0
BA0014D0028495BA00131D003156MC0
BA0014D0028496BA00111F001588MC0
BA0014R0064057BA00131A001226MC-0
Total -172

If I want to show only the minus values, how can I do that?

Regards,

Priyantha.

1 Solution

Accepted Solutions
jyothish8807
Master II
Master II

Hi Priyantha,

1. Try with set analysis in a straight chart,

only({<ORC_COM_DIFF={"<0"}>}ORC_COM_DIFF)

2. or in your load statement you can try like this

Load *

from table 1

where ORC_COM_DIFF < 0;

Regards

KC

Best Regards,
KC

View solution in original post

2 Replies
jyothish8807
Master II
Master II

Hi Priyantha,

1. Try with set analysis in a straight chart,

only({<ORC_COM_DIFF={"<0"}>}ORC_COM_DIFF)

2. or in your load statement you can try like this

Load *

from table 1

where ORC_COM_DIFF < 0;

Regards

KC

Best Regards,
KC
jagan
Partner - Champion III
Partner - Champion III

Hi,

Try like this

If(Expression < 0, Expression)

Note: Replace Expression with your actual expression (Ex.Sum(ORC_COM_DIFF)), hope this helps you.

Regards,

Jagan.