Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count number of duplicate and where they visited?

Hi All,

I would like to seek your advise on the script (please paste here as I am using the personal edition). Thank in advance.

I have a very long list will be only showing a subset over here in table 1 and the answer I am looking at is:

           ANSWER

Row LabelsShopLeisureDrinkPlayFunEatNO of events
A3 1 4
B 3 1 4
C 3 14
D 2 2
E 2 2
F 22
G1 1

Table 1   

CustomersPlace of visit
AShop
BLeisure
CDrink
EPlay
DFun
FEat
AShop
BLeisure
CDrink
EPlay
DFun
FEat
AShop
BLeisure
CDrink
APlay
BFun
CEat
GShop
11 Replies
sunny_talwar

Like this?

Capture.PNG

Pivot Table

Dimensions

Customers

Place of visit -> Enable Partial Sum on the presentation tab for this dimension

Expression

Count(Customers)

Not applicable
Author

I wasn't able to do a sort based on descending order on the column "TOTAL". how to do that?

Also If I want to tabulate the column "TOTAL" into a bar chart like number of time the '1' appear, number of time the '2' appear and so on.

For your kind advise.

sunny_talwar

A bar chart like this?

Capture.PNG

Calculated dimension

=Aggr(Count(Customers), Customers)

Expression:

Count(Customers)

For sorting I will have to play around with the data a little. Would you be able to  try this sorting expression (and uncheck all other options)

=Aggr(Count(TOTAL <Customers> Customers), Customers, [Place of visit])

also make sure the order is descending

Not applicable
Author

for the bar chart, how can I exclude "1" and only show the rest?

Not applicable
Author

for your advise,pls

Not applicable
Author

for the bar chart, how can I exclude "1" and only show the rest?

sunny_talwar

Use this expression:

If(Count(Customer) > 1, Count(Customer))

Not applicable
Author

Hi Sunny,

I used this expression If(Count(Customer) > 1, Count(Customer)) instead of the earlier Count (Customer), but I wasn't able to exclude the bar chart with 1 count.

Can you please assist?

dinuwanbr
Creator III
Creator III

Hi,

PFA

Rgds,

Dinu1