topic Re: Count straight table rows in QlikView

Count straight table rows

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

Hi All,

Kindly help me to count the number of rows in a straight table.

Example:

Note : '-' is Null in the above screenshot.

I have tried count(distinct Dimension) , I am getting 5.But the expected count is 3 excluding Nulls.

Thanks

Dinesh M

Re: Count straight table rows

its_anandrjs — Wed, 13 Sep 2017 09:15:32 GMT

Try expression

count(distinct If(Dimension <> '-' or Dimension = isnull() or Dimension = 0, Dimension) )

Re: Count straight table rows

Kushal_Chawda — Wed, 13 Sep 2017 09:40:23 GMT

try below expression

=count(distinct {<Dimension={"=(Expression)>0"}>}Dimension)

Re: Count straight table rows

its_anandrjs — Wed, 13 Sep 2017 09:44:09 GMT

Another version

=Count( Distinct {<Dimension -= {"=(Isnull(Dimension)) = -1"}>} Dimension )

Re: Count straight table rows

Anonymous — Wed, 13 Sep 2017 09:47:03 GMT

Try this SetAnalysis

=count(distinct {<Dimension={"=(Expression)>0"}>}Dimension)

It will Suppress your Null value OR Value with 0

Regards

Tahemas Momin

Re: Count straight table rows

YoussefBelloum — Wed, 13 Sep 2017 09:50:27 GMT

Hi Dinesh,

Try this on the script :

if(expression <> '' or not isnull(expression),1,0) as count

Regards,

Youssef

Re: Count straight table rows

its_anandrjs — Wed, 13 Sep 2017 09:56:37 GMT

Try some of this

=Count(distinct If(Expression <> '-' or Expression = Isnull() or Expression = 0, Dimension) )

=Count(distinct If( Isnull(Expression) <> -1, Dimension) )

=Count( Distinct {<Expression-= {"=(Isnull(Expression)) = -1"}>} Dimension )

Re: Count straight table rows

sunny_talwar — Wed, 13 Sep 2017 12:22:46 GMT

What is your expression here?

Re: Count straight table rows

Brice-SACCUCCI — Wed, 13 Sep 2017 12:29:59 GMT

Hello,

what about the following set analysis?

Count( DISTINCT {$<Dimension = {"=NullCount(Expression) > 0"}>} Dimension)

Regards,

Brice

Re: Count straight table rows

its_anandrjs — Wed, 13 Sep 2017 12:30:31 GMT

I believe Expression is that you have some Metric calculation, if it is same than replace the Expression place with your expression.

Kindly check this also will it work for you.