topic Re: Count in QlikView

Count

gautik92 — Thu, 12 Feb 2015 09:15:17 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

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

Hi Gowtham,

This is a duplicate thread, you created one more thread. Anyway trythis solution

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 — Thu, 12 Feb 2015 09:24:47 GMT

I want to represent in text box

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

HI,

Try like this

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

Regards,

Jagan.