Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count Rows in Table Diagramm

Hi, I am pretty new to Qlikview and got the following issue.

I created a table diagram like:

column A | column B | column C | column D
Value A         Value A     Value A          10
Value A         Value A     ValueB            20
Value A         Value A     Value C          3
Value A         Value B     Value A          12
Value C         Value A      Value A         77


and so on.


Now I want to know, how many lines do I have in this diagram?
When I use the count or text count function, Qlikview always counts the amount of rows in the root table ( database ).
I just want to know how I can count the lines / rows I got in the respective table diagram.

Thanks for your input,

Regards Mathias

Labels (1)
11 Replies
its_anandrjs
Champion III
Champion III

Hi,

Please see the attached example it shows some thing like this

load *,recno() as Reco_No;

 

LOAD * INLINE [

    column A, column B, column C, column D

    Value A, Value A, Value A, 10

    Value A, Value A, ValueB, 20

    Value A, Value A, Value C, 3

    Value A, Value B, Value A, 12

    Value C , Value A, Value A, 77

];

Regards,

Anand

hugmarcel
Specialist
Specialist

ok, but this solution does not work if dimension limits filter the table data...

Any solution available with dimension limits included?

thx - marcel