topic Re: Count of fields in QlikView

Count of fields

kushalthakral — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

i have a following requirement below

i need to calculate the count of customers and display in a separate column

as in the case above it is 9 which includes duplicate also need to consider that also

Can any one help me on this

Thanks

Kushal

swuehl — Tue, 14 Jun 2016 16:35:53 GMT

Table:

LOAD Campaign, Customer, Years

FROM...;

JOIN

LOAD Count(Customer) as Count

RESIDENT Table;

swuehl — Tue, 14 Jun 2016 16:38:09 GMT

If you are not looking for a script solution, you would need to define the exact context in which you want to create the column.

Again, it's much easier to help if you create and post a small sample QVW.

Regards,

Stefan

maxgro — Tue, 14 Jun 2016 17:05:21 GMT

you can try with TOTAL in a chart

count(TOTAL Customer)

or by Campaign

count(TOTAL <Campaign> Customer)

susovan — Wed, 15 Jun 2016 04:41:15 GMT

Hi Kushal,

PFA

Try this

You also try this way,

kushalthakral — Wed, 15 Jun 2016 09:45:00 GMT

Hi All

i have solved this by using below formula

Sum(Total<[Years with Company],[Campaign Name]>Aggr(Count(Total<T>distinct T),[Campaign Name],T))