topic Re: Table Diagram Count Rows in QlikView

Table Diagram Count Rows

Mon, 22 Oct 2012 09:51:59 GMT

Hi everyone,

i have a table diagram with 6 very complex dimensions.

I want to show the number of rows (shown in the diagram) in diagram title.

Can anyone help me?

Re: Table Diagram Count Rows

Anonymous — Mon, 22 Oct 2012 09:55:59 GMT

Is there one dimension with a row of data for each dimension value?

In that case, you can do a count of the dimension.

Re: Table Diagram Count Rows

Mon, 22 Oct 2012 09:58:14 GMT

Hi,

U can write the expression like bellow in the tittle text box.

='Diagram Tittle'& count(Your Dimension(Any one from your 6 Dimension))

Hope This helps you

Regards,

Kabilan K.

Re: Table Diagram Count Rows

Mon, 22 Oct 2012 10:55:50 GMT

The dimensions are complex expressions.

One of this dimensions (dim1) looks like this:

=aggr(if(count(if(startTime>= timestamp(date(today()-1)+'06:00:00'), if( startTime <= timestamp(date(today())+'06:00:00'),if(CompletionNr=-1,CompletionNr))))>0, count(if(startTime >= timestamp(date(today()-1)+'06:00:00'), if( startTime <= timestamp(date(today())+'06:00:00'),if(CompletionNr=-1,CompletionNr))))), KeyClientNrBackupsetID, TypDescription)

If I use this dimension as count in the diagram title the result is different to the count of another dimension.

Re: Table Diagram Count Rows

Mon, 22 Oct 2012 11:45:23 GMT

Hi,

Count function Counts a 0 and null value also,

For example,

Myfield

null

So here Count(Myfield)=7 not 5

If u want 5 or u want to avoid the null and 0 values while count use this ='Diagram Tittle '&count({<Myfield-={'',0}>} Myfield)

Hope this helps you.

Regards,

Kabilan K.

Re: Table Diagram Count Rows

Tue, 23 Oct 2012 09:24:27 GMT

Hi,

my question is:

I want to show the number of rows of the table diagram in the title.

Is it necessary to create a if-statement in combination of all complex dimensions of the diagram to get the number of rows? Or is it possible to get the (count of the) content easier?

I have 6 complex dimensions and the if-statement in the title would be very complex.