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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
BenGielen
Contributor III
Contributor III

only see orders with value bigger than zero

Hello Community,

i have a question to qlik sense table.

I have a table with two columns. First column is the order number and second is the open value per order.

How can i make it that only the order numbers are shown where the open value is more then zero?

i only want to see the orders with open value >0.

Thank you for your help. 

Examble table:

Order Numberopen value
10,00
22300,00
34500,00
40,00
51300,00
64000,00
70,00
80,00
90,00

 

result should be:

Order Numberopen value
22300,00
34500,00
51300,00
64000,00

 

MFG Ben

1 Solution

Accepted Solutions
Quy_Nguyen
Specialist
Specialist

Hi,

Just simply create a table with:

+ Dimension: OrderNumber

+ Measure: Sum(value)

Then in the OrderNumber dimension setting, set the limitation to the Exact Value, choose  larger than 0 and uncheck Show others:

clipboard_image_1.png

Hope it helps.

View solution in original post

5 Replies
naumanshah
Contributor III
Contributor III

You can add a WHERE clause in Data Load Editor right under the table name:

... from orders

WHERE [open value]>0;

BenGielen
Contributor III
Contributor III
Author

can i also do this direct in the dimension formel from order number?

 

Kashyap_R
Partner - Specialist
Partner - Specialist

Hi 

You can go to data handling uncheck Include Zero values option

Hope it helps

Thanks

Thanks and Regards
Kashyap.R
Quy_Nguyen
Specialist
Specialist

Hi,

Just simply create a table with:

+ Dimension: OrderNumber

+ Measure: Sum(value)

Then in the OrderNumber dimension setting, set the limitation to the Exact Value, choose  larger than 0 and uncheck Show others:

clipboard_image_1.png

Hope it helps.

BenGielen
Contributor III
Contributor III
Author

Thank you all.

Thank you Quy_Nguyen this works perfectly. 

**bleep** such an easy solution...🙈

Greetings Ben