Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Count of fields

Hi All

i have a following requirement below

 

CampaignCustomerYears with CompanyCount
A189
A289
A389
A489
A589
A689
A789
A889
A889

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

5 Replies
MVP
MVP

Table:

LOAD Campaign, Customer, Years

FROM...;

JOIN

LOAD Count(Customer) as Count

RESIDENT Table;

MVP
MVP

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

MVP
MVP

you can try with TOTAL in a chart

count(TOTAL Customer)

or by Campaign   

count(TOTAL <Campaign> Customer)

1.png

Partner
Partner

Hi Kushal,

PFA

Try this

1.JPG

You also try this way,

2.JPG

Creator III
Creator III

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))