Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exclude Values


I have a total of 100 million rows. Wanted an efficient method to exclude rows from a data set with straight table:

Name Value1 Value2

a          100        0

b           200      200

c            0         20

Dimension = Name

Dimension Expression 1= Value1

Dimension expression 2 =Value 2

Note: The dimension expression are created using set analysis.

What I want is:

1) I want Name only for Value1 > 0 (a and b) Then

2) I want Name where Value2 > 0 (b)

Basically I want to eliminate names where both Value 1 and Value 2 are zeros.

Any help is appreciated. The solution should work on large sets of data.

1 Reply
MVP & Luminary
MVP & Luminary

Re: Exclude Values


Use Dimension = Name

Expression Value1= Sum({<Value1={'>0'}>} Value1)

Expression Value2= Sum({<Value1={'>0'}>} Value2)

Hope this helps you.