Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gautik92
Specialist III
Specialist III

Count

I have a table wiith column name Approval status as

0.created

1,approved

2.cancelled

how can i count the individual 0,1,2

13 Replies
Anonymous
Not applicable

Hello,

Please provide sample data

Thanks

anbu1984
Master III
Master III

gautik92
Specialist III
Specialist III
Author

C.png

I have data like this i want to count how many 1 in this column

anbu1984
Master III
Master III

In Script,

Load ApprovalStatus,Count(ApprovalStatus) From Table Group By ApprovalStatus;

Anonymous
Not applicable

Set an object with dmension ApprovalStatus, and expression =count(ApprovalStatus.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

Chart : Straight Table

Dimension: [Approval Status]

Expression: Count([Approval Status])

Or use  [Approval Status] as list box and select Show Frequency option in General tab.

Regards,

Jagan.

gautik92
Specialist III
Specialist III
Author

i want to count in text box.

i want to show how many 1's and how many 2's

anbu1984
Master III
Master III

Check my solution in this link ttp://community.qlik.com/message/610192

jagan
Luminary Alumni
Luminary Alumni

HI,

Try like this

=Concat(Aggr(Status & ':' & Count(Status), Status), Chr(13))

Regards,

Jagan.