topic Re: Unique Count from 2 different fields in single expression in QlikView

Unique Count from 2 different fields in single expression

Thu, 24 Sep 2015 12:20:51 GMT

Hi All,

So this is the issue, i have to show unique count from 2 separate fields in a single text box.

The confusion is how to find distinct value from 2 columns in single expression.

I have created a POC, 2 columns are F1 and B1, also i have also got a solution to it but i think by doing that my application could get super loaded(getting all values in a variable and values can go into millions).

PFA poc and let me know if there is any other simple way to do this.

Thanks,

ASP

Re: Unique Count from 2 different fields in single expression

swuehl — Thu, 24 Sep 2015 12:33:52 GMT

Maybe like

=Count(Distinct F1) + Count({<B1 -= p(F1) >}Distinct B1)

Re: Unique Count from 2 different fields in single expression

Thu, 24 Sep 2015 12:37:46 GMT

Yes this works too, thanks Swuehl..

Just one query this wouldn't be too heavy to use right, i stressing on this is because already my application has grown very much

Re: Unique Count from 2 different fields in single expression

rolandies — Thu, 21 Nov 2019 14:21:40 GMT

And if you want to include a third discount field?