Discussion board where members can get started with QlikView.
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
LOAD Campaign, Customer, Years
LOAD Count(Customer) as Count
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.
you can try with TOTAL in a chart
or by Campaign
count(TOTAL <Campaign> Customer)
You also try this way,
i have solved this by using below formula
Sum(Total<[Years with Company],[Campaign Name]>Aggr(Count(Total<T>distinct T),[Campaign Name],T))