topic Re: Count Of Field in QlikView

Count Of Field

Anonymous — Tue, 22 Mar 2016 10:25:15 GMT

Hi All

Need Help with this please.

Count(Distinct({<Field = {[0]}>}%Acct))

i want to Count %Acct but the field is [0]

Thanks Again!

Re: Count Of Field

sunny_talwar — Tue, 22 Mar 2016 10:27:01 GMT

It shows the value as [0] or 0?

Count(DISTINCT {<Field = {0}>} [%Acct])

Re: Count Of Field

Kushal_Chawda — Tue, 22 Mar 2016 10:27:40 GMT

try this

Count(Distinct({<Field = {'0'}>}%Acct))

Re: Count Of Field

Anonymous — Tue, 22 Mar 2016 10:30:15 GMT

Sorry i think i confused you guys, I mean Count the Field

.......Name of field is [0]

So its Count Distinct %Acct where [0] in a straight Table

Re: Count Of Field

sunny_talwar — Tue, 22 Mar 2016 10:32:01 GMT

where [0] is available?

Count({<[0] = {'*'}>}[%Acct])

Re: Count Of Field

Gysbert_Wassenaar — Tue, 22 Mar 2016 10:32:12 GMT

Where [0] is what??

Re: Count Of Field

Chanty4u — Tue, 22 Mar 2016 10:33:25 GMT

= Count(Distinct {<field= {'value'}>}%act)

Re: Count Of Field

Anonymous — Tue, 22 Mar 2016 10:33:37 GMT

e.g

I have 10 fields

0 to 10

I am suming money

I want to know how much account this group has

So i have a new Expression sum the accounts per month

Re: Count Of Field

Anonymous — Tue, 22 Mar 2016 10:34:32 GMT

Sorry i want to just sum the field not add a value

Re: Count Of Field

sunny_talwar — Tue, 22 Mar 2016 10:35:02 GMT

May be you want to do a distinct count of the [0] field itself?

Count(DISTINCT [0])

Re: Count Of Field

Chanty4u — Tue, 22 Mar 2016 10:36:22 GMT

use simply

count(Distinct [Fieldname])

Re: Count Of Field

Kushal_Chawda — Tue, 22 Mar 2016 10:39:56 GMT

=sum(aggr(count( distinct %act),[0]))

Re: Count Of Field

sunny_talwar — Tue, 22 Mar 2016 10:41:28 GMT

Kush today is your Aggr day

I am seeing Aggr() in all your proposed solutions

Re: Count Of Field

Anonymous — Tue, 22 Mar 2016 10:44:48 GMT

I have attached a Test Doc

I wanted a Count of Accounts for the Group

Re: Count Of Field

Kushal_Chawda — Tue, 22 Mar 2016 10:45:17 GMT

Yeah, feeling like to use Aggr. Not good but requirements seems like that

Re: Count Of Field

Chanty4u — Tue, 22 Mar 2016 10:46:21 GMT

Count({$<filed={'[0]'}>} DISTINCT %act)

Re: Count Of Field

sunny_talwar — Tue, 22 Mar 2016 10:48:11 GMT

I don't see any field names as [0]

Re: Count Of Field

Anonymous — Tue, 22 Mar 2016 10:49:32 GMT

Sorry i wrote Month in Test Script

The Month should be 0 then same data for 1 then same data for 2 etc

Re: Count Of Field

sunny_talwar — Tue, 22 Mar 2016 10:49:51 GMT

Try this:

Sum({<Month = {0}>}Money)

Re: Count Of Field

sunny_talwar — Tue, 22 Mar 2016 10:52:45 GMT

Or may be a pivot table like this?

Month as second dimension here and Sum(Money) as the expression