Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Combine two fields count non-null values in Straight Tables

Combine two fields and count only non null value. Please refer sample screenshot for better understanding.

Capture.JPG

T1:

LOAD * INLINE [

    AAA, BBB

    1, 567

    2, 568

    2, 569

    3, 570

    3, 571

    4, 572

    5, 573

    , 574

    , 575

];

1 Solution

Accepted Solutions
Highlighted

Re: Combine two fields count non-null values in Straight Tables

or Count({<AAA = {"*"}>}BBB)

View solution in original post

3 Replies
Highlighted

Re: Combine two fields count non-null values in Straight Tables

May be just this.... Count(AAA)

Highlighted

Re: Combine two fields count non-null values in Straight Tables

or Count({<AAA = {"*"}>}BBB)

View solution in original post

Highlighted
Creator II
Creator II

Re: Combine two fields count non-null values in Straight Tables

Thanks Sunny