topic Re: Count in QlikView

Count

noman212 — Tue, 21 Oct 2014 07:09:42 GMT

Hi friends,

i have a date field, from which i made month ... like jan, feb , mar..

Now i want to calculate the count of these month in Month(Date) fieled.

For Example.

In Month field i have JAN,FEB, MARCH.

I want Count of these month as 3 . Simple count is not working.

Re: Count

tresB — Tue, 21 Oct 2014 07:12:18 GMT

Count( Distinct YourMonthField)

Re: Count

PrashantSangle — Tue, 21 Oct 2014 07:13:18 GMT

Hi,

What is your expression?

Count(distinct Month) should work if want count of distinct Month

Count(Month) gives count of all month

Regards

Re: Count

Tue, 21 Oct 2014 07:14:09 GMT

Hello,

I am not sure I understand your question. do u want to do a distinct count of the values in the Month field? do wish to do this is a script or a chart? what does the count you have created returns?

Nir

Re: Count

ashfaq_haseeb — Tue, 21 Oct 2014 07:15:21 GMT

Hi,

use distinct keyword.

Regards

ASHFAQ

Re: Count

jagan — Tue, 21 Oct 2014 07:15:24 GMT

Hi,

Try using Count() and Distinct

Count( Distinct MonthDimensionName)

Regards,

Jagan.

Re: Count

noman212 — Tue, 21 Oct 2014 07:20:56 GMT

Its display count for whole year i want listed month count , in my qvd i have only 3 months records.

Re: Count

ashfaq_haseeb — Tue, 21 Oct 2014 07:23:16 GMT

Can you post sample

Count( Distinct [Yourmonthfield]) must work.

Regards

ASHFAQ

Re: Count

noman212 — Tue, 21 Oct 2014 07:27:28 GMT

Its Work fine Thanks alot

Re: Count

noman212 — Tue, 21 Oct 2014 07:28:42 GMT

Thanks again jagan mohan

Re: Count

Tue, 21 Oct 2014 11:18:03 GMT

Count(distinct Month) will work