topic Re: Count in QlikView

Count

gautik92 — Thu, 12 Feb 2015 09:14:48 GMT

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

Re: Count

Anonymous — Thu, 12 Feb 2015 09:15:51 GMT

Hello,

Please provide sample data

Thanks

Re: Count

anbu1984 — Thu, 12 Feb 2015 09:18:05 GMT

Duplicate thread http://community.qlik.com/thread/151744

Re: Count

gautik92 — Thu, 12 Feb 2015 09:18:32 GMT

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

Re: Count

anbu1984 — Thu, 12 Feb 2015 09:20:20 GMT

In Script,

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

Re: Count

Anonymous — Thu, 12 Feb 2015 09:21:12 GMT

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

Re: Count

jagan — Thu, 12 Feb 2015 09:21:16 GMT

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.

Re: Count

gautik92 — Thu, 12 Feb 2015 09:22:05 GMT

i want to count in text box.

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

Re: Count

anbu1984 — Thu, 12 Feb 2015 09:31:49 GMT

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

Re: Count

jagan — Thu, 12 Feb 2015 09:32:52 GMT

HI,

Try like this

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

Regards,

Jagan.

Re: Count

anbu1984 — Thu, 12 Feb 2015 09:35:47 GMT

Concat(Aggr(Max(ApprovalStatus) & ':' & Count(ApprovalStatus),ApprovalStatus),Chr(13))

Re: Count

alexandros17 — Thu, 12 Feb 2015 09:41:02 GMT

Here is my example

Re: Count

sujeetsingh — Thu, 12 Feb 2015 09:42:06 GMT

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

Re: Count

jagan — Thu, 12 Feb 2015 09:42:43 GMT

Hi,

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.

Regards,

Jagan.