Solved: Re: How to display number of row of my table at To... - Qlik Community

paulyeo11 · ‎2014-06-10

Hi All

I hv a table , and i like to display number of row on Top left conner.

Paul

tresesco · ‎2014-06-10

Hi Paul,

I thought that the solution would be easier. But your's is a bit complex. I got it using a macro and variable. See attached solution.

Sub CountRow

set chart = ActiveDocument.GetSheetObject("CH230816")
set v = ActiveDocument.Variables("RowsNum")
v.SetContent chart.GetNoOfRows,true

End Sub

Cheers.

View solution in original post

Report Inappropriate Content · ‎2014-06-10

Hi Paul,

PFA

-- Rajendra

Report Inappropriate Content · ‎2014-06-10

='Total Number of Row = ' & count(PART_NO_)

Sokkorn · ‎2014-06-10

Paul,

Did you try expression in Window Title yet?

='Total Number of Row =' & Count(PART_NO_)

Rgds,

Sokkorn

tresesco · ‎2014-06-10

PFA

Update: Count( Distinct PART_NO_)

Report Inappropriate Content · ‎2014-06-10

Hi Paul,

Please find attachment and see the answer where you want.

Garry

paulyeo11 · ‎2014-06-10

Hi All

Thank you for the reply. but my PART_NO_ some have missing value , may i know how to count those with missing value ?

Paul

Report Inappropriate Content · ‎2014-06-10

are you asking abount missing means NULL values??

Report Inappropriate Content · ‎2014-06-10

Hi Paul,

Request you to add one list box of PART_NO_ which shows you that there is no missing value. That missing values comes from your expression.

Garry

paulyeo11 · ‎2014-06-10

SEe the image above. notice the row count and part number count are diff.

How to display number of row of my table at Top left conner ?