I have a table wiith column name Approval status as
how can i count the individual 0,1,2
Please provide sample data
I have data like this i want to count how many 1 in this column
Load ApprovalStatus,Count(ApprovalStatus) From Table Group By ApprovalStatus;
i want to count in text box.
i want to show how many 1's and how many 2's
Check my solution in this link ttp://community.qlik.com/message/610192
Try like this
=Concat(Aggr(Status & ':' & Count(Status), Status), Chr(13))
Concat(Aggr(Max(ApprovalStatus) & ':' & Count(ApprovalStatus),ApprovalStatus),Chr(13))
Set an object with dmension ApprovalStatus, and expression =count(ApprovalStatus.
Duplicate thread http://community.qlik.com/thread/151744
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.
Here is my example
Just tale the number as Subfield(Status,',',1) or subfield(Status,'.',1) this will only return the integer part of the string and hence you can add them
If you got the answer please Close this thread by giving correct and helpful answers to the posts which helps you in getting the answers. So that it helps others to find answers easier.
Retrieving data ...