Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2011-02-15 03:51 PM

Get Chart Row Count

I have a macro that I use to put a chart's row count in the caption of straight tables. But in the case below it's not correct due to repeated values of this particular chart. Does anyone know how I can get the DISTINCT count of the first dimension in order to display it in the caption?

error loading image

4,358 Views
0 Likes
10 Replies
pover
Luminary Alumni
Luminary Alumni
‎2011-12-23 01:06 PM

In response to

PC Rao,

A table box will show 1 row for each unique set of data.  In an ideal data table a count() should match the number of rows you have in the tablebox.  There is no countTableBox() function. 

The issue you are having probably has more to do with the data than QlikView. In these cases do the count and select a small subset of data until the count and the number of rows match.  Then select another small subset that doesn't match the count and note the differences until you are able to figure out what inconsistency lies in the data you are using.

I'm sorry I don't have an easy answer.

Regards, Karl

189 Views
0 Likes