Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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
Partner - Champion III
Partner - Champion III

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])