topic Re: count Two column values are equal in QlikView

count Two column values are equal

jixiaoquan — Mon, 26 Jan 2026 16:26:21 GMT

Hi everybody,

I meet a problem,How to count how many ID which Start equals End?

=count({<Start=End>} ID) ?

sunny_talwar — Thu, 12 May 2016 09:38:30 GMT

Try this:

Count(DISTINCT {<ID = {"=Start = End"}>} ID)

Kushal_Chawda — Thu, 12 May 2016 09:42:40 GMT

Count (distinct If(Start=End, ID) )

trdandamudi — Thu, 12 May 2016 09:45:04 GMT

May be this:

=Count({$<ID={"=Start =End"}>}ID)

Thu, 12 May 2016 09:45:41 GMT

=if(Start=End, count(ID) )

jixiaoquan — Mon, 16 May 2016 07:29:54 GMT

Hi Sunny ,

Thanks a lot.You are right.

jixiaoquan — Mon, 16 May 2016 07:43:27 GMT

Hi kushal,

Thank you for your answer.Your answer is wrong ,but I do not know why!

The right answer is :Count(DISTINCT {<ID = {"=Start = End"}>} ID)

Thank you very much.