topic Re: Count non null rows in chart table. in QlikView

Count non null rows in chart table.

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

Hi Experts

Please find attached sample qvw, i am trying to show non null values from column named 'Action Items' in text box.

Any suggestions?

Thanks in advance, .

Re: Count non null rows in chart table.

trdandamudi — Thu, 27 Oct 2016 04:15:30 GMT

Use the below expression in your text box:

=Count({<Action={'*'}>} Action)

Re: Count non null rows in chart table.

ashishpalkar — Thu, 27 Oct 2016 04:21:31 GMT

Thanks Thirumala , its calculating distinct values, I am looking count of all.

Re: Count non null rows in chart table.

tamilarasu — Thu, 27 Oct 2016 04:22:48 GMT

Hi Ashish,

You can also try,

=Count({<Action={"=Len(Trim(Action))>0"}>} Action)

Re: Count non null rows in chart table.

trdandamudi — Thu, 27 Oct 2016 04:30:33 GMT

Got it.. Then Tamil's expression should work for you. If still have issue please let us know.

Re: Count non null rows in chart table.

ashishpalkar — Thu, 27 Oct 2016 04:35:29 GMT

Thanks , still showing distinct values.

Re: Count non null rows in chart table.

trdandamudi — Thu, 27 Oct 2016 04:38:48 GMT

I don't think even Tamil's expression will work, Because you have 150 rows and out of that only 15 of them are non nulls in the column 'Action' and remaining are all nulls. So based on your requirement, you want count of non nulls in the column 'Action'. Based on the expression provided by me and Tamil is giving you 15.

If this is not correct, Can you please explain little bit more with the expected output.

Re: Count non null rows in chart table.

tamilarasu — Thu, 27 Oct 2016 04:45:51 GMT

As mentioned by Thirumala, you have only 15 non null values in your example file.

Re: Count non null rows in chart table.

Anil_Babu_Samineni — Thu, 27 Oct 2016 05:03:10 GMT

Then, Use Distinct Function

=Count({<Action={"$(=Len(Trim(Action))>0)"}>} DISTINCT Action)

Count non null rows in chart table.

Re: Count non null rows in chart table.

sunny_talwar — Thu, 27 Oct 2016 10:07:34 GMT

I agree with tamilarasu and trdandamudi‌. There are only 15 non-null action rows. What else are you expecting to see, if not 15?