Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Please provide sample data
Thanks
Duplicate thread http://community.qlik.com/thread/151744
I have data like this i want to count how many 1 in this column
In Script,
Load ApprovalStatus,Count(ApprovalStatus) From Table Group By ApprovalStatus;
Set an object with dmension ApprovalStatus, and expression =count(ApprovalStatus.
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.
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
HI,
Try like this
=Concat(Aggr(Status & ':' & Count(Status), Status), Chr(13))
Regards,
Jagan.