Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

paulyeo11
Valued Contributor II

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

Hi All

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

Paul

1 Solution

Accepted Solutions
MVP
MVP

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

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.

14 Replies
Not applicable

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

Hi Paul,

PFA

-- Rajendra

Not applicable

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

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

Sokkorn
Honored Contributor

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

Paul,

Did you try expression in Window Title yet?

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

Rgds,

Sokkorn

MVP
MVP

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

PFA

Update: Count( Distinct PART_NO_)

Not applicable

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

Hi Paul,

Please find attachment and see the answer where you want.

Garry

paulyeo11
Valued Contributor II

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

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

Not applicable

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

are you asking abount missing means NULL values??

Not applicable

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

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
Valued Contributor II

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

value same.png

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

Community Browser