Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Count Of Field

Hi All

Need Help with this please.

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

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

Thanks Again!

1 Solution

Accepted Solutions
Chanty4u
MVP
MVP

29 Replies
sunny_talwar

It shows the value as [0] or 0?

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

Kushal_Chawda

try this

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

Anonymous
Not applicable
Author

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

sunny_talwar

where [0] is available?

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

Gysbert_Wassenaar

Where [0] is what??


talk is cheap, supply exceeds demand
Chanty4u
MVP
MVP

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

sunny_talwar

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

Count(DISTINCT [0])