topic Re: Counting rows in data in QlikView

Counting rows in data

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

Hi,

I have A-E, 5 columns/variables in my data.

Lets say A has 3 options MD,SD and RT.

I have created a multibox to sort with SD and count the entries.

Can I do the same with a text box containing formula? such as

=(Count( DISTINCT {<A={"SD"}>} A))

Re: Counting rows in data

lockematthewp — Mon, 29 Jul 2019 15:05:49 GMT

yes that would provide you with the number of distinct values in A. You can also display them by having a text box with =concat(distinct {<[A]={'SD'}>} [A], ',')

Re: Counting rows in data

abhi1693r — Mon, 29 Jul 2019 15:21:04 GMT

I wanted to count instead of concat, what should I do?

Re: Counting rows in data

lockematthewp — Mon, 29 Jul 2019 15:29:21 GMT

Your original expression will return the count.

=(Count( DISTINCT {<A={"SD"}>} A))

Re: Counting rows in data

abhi1693r — Mon, 29 Jul 2019 19:05:35 GMT

I was trying something like

=(Count( DISTINCT {<A={"SD"}>}{<B={"TD"}>} A))

And I noticed that only A=SD condition is applying but B=TD is NOT.

Is there a way to implement both conditions together with 'OR' logical operator??

Re: Counting rows in data

lockematthewp — Tue, 30 Jul 2019 13:00:02 GMT

+ is used for or in set analysis.

=(Count( DISTINCT {<A={"SD"}>}+{<B={"TD"}>} A))