topic Get Chart Row Count in QlikView

Get Chart Row Count

Anonymous — Tue, 15 Feb 2011 20:51:19 GMT

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?

Get Chart Row Count

pover — Tue, 15 Feb 2011 21:42:20 GMT

Brian,

Is there anything wrong with using the following expression as a caption?

='Orders On Hold (' & count(distinct SO_NUM) & ')'

Regards.

Get Chart Row Count

Anonymous — Tue, 15 Feb 2011 21:49:04 GMT

Unfortunately, that returns the number of distinct orders in the entire data set, not within just this chart (I have an expression with set analysis which limits which orders appear in this chart).

Get Chart Row Count

Oleg_Troyansky — Tue, 15 Feb 2011 21:56:47 GMT

Brian,

you'd need to repeat the same Set Analysis expression in your count(distinct ...).

cheers,

Get Chart Row Count

pover — Tue, 15 Feb 2011 22:04:10 GMT

Yeah, I had a feeling it wasn't that easy.

However, you could use the same set analysis in the count as in the expressions or something like the following.

='Orders On Hold (' & count({$<SO_NUM={"=expression1<>0 and expression2<>0"}>} distinct SO_NUM) & ')'

Regards.

Get Chart Row Count

Anonymous — Tue, 15 Feb 2011 22:34:57 GMT

That did it, thanks.

Get Chart Row Count

Sun, 18 Dec 2011 11:44:42 GMT

Hi can you please help me how to find the no of records displying in a table box object based on various filters. I can able to see the no of records on a status bar, but i want to display that number value in a text object or in the header of the table box object.

Get Chart Row Count

Fri, 23 Dec 2011 01:03:08 GMT

i used below two expressions but not giving the right number.

='No of reccords in the table : ' & COUNT (DISTINCT [CustomerCode])

='No of reccords in the table : ' & COUNT (DISTINCT [CustomerCode]&[CustomerTitle]&[FirstName]&[LastName]&[Gender]&[Age]&[MarketingCampaignCode]&[MktgCampaignLongName]&[MarketingDate]&[ResponseCampaignCode]&[RespCampaignLongName]&[ResponseDate]&[CouponReceived]&[ResponseMethod]&[ContactDepartment]&[PA_FlatNumber]&[PA_HouseNumber]&[PA_HouseName]&[PA_StreetName]&[Locality]&[Town]&[PA_Country]&[PA_Zipcode]&[CustomerType]&[PreferredBranch_DaycentreCode]&[Dispenser]&[AppointmentDate]&[AppointmentType]&[TelephoneNo]&[MobilePhoneNo]&[PostcodeSector])

Its urgent for me....please help.

Get Chart Row Count

pover — Fri, 23 Dec 2011 16:45:59 GMT

What happens if you get rid of the distinct?

COUNT ([CustomerCode])

Karl

Get Chart Row Count

Fri, 23 Dec 2011 17:51:13 GMT

Hi Karl

That's also not giving right number. I would like to know how many records are displayed in table object. It's result I can able to see on status bar when table object is selected. So I want to display in a text box so that user can able to know the count always though table object is not selected.

I need some one help on this. Please reply if any one having the solution for it.

Thanks

PC Rao

Get Chart Row Count

pover — Fri, 23 Dec 2011 18:06:59 GMT

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