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

Combine two fields count non-null values in Straight Tables

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

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

T1:

LOAD * INLINE [

AAA, BBB

1, 567

2, 568

2, 569

3, 570

3, 571

4, 572

5, 573

, 574

, 575

];

sunny_talwar — Thu, 19 Jul 2018 15:27:27 GMT

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

sunny_talwar — Thu, 19 Jul 2018 15:27:58 GMT

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

karan_kn — Thu, 19 Jul 2018 15:40:36 GMT

Thanks Sunny