Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

hopkinsc
Valued Contributor

Getting the number of deliveries.

Hi,

I have the following table:

Sample.JPG

I want to add an expression which will give me the number of deliveris per week. This can be done be either counting the Delivery Days or getting the highest Sequence.

eg.

The customer SPAR STORE BRACKLA has an order on MONDAY, WEDNESDAY,THURSDAY AND FRIDAY which =4 deliveries per week.

You can also see this by looking at the SEQUENCE, the higest is 4 which means they have 4 deliveries per week.

I want to this to appear on each line. So for the mentioned customer, i would want 4 along side each line relating to them.

I tried Count(DeliveryDay) but that didnt give the total. and i tried Max(Sequence) but that just puts the same sequesnce number against each line.

Can anyone help please?

Chris

2 Replies
Highlighted
MVP
MVP

Getting the number of deliveries.

I think you need to add TOTAL<CustName> to your expressions, like

=max(total<CustName> Sequence)

Do you have only data for one week?

hopkinsc
Valued Contributor

Getting the number of deliveries.

Hi Stefan.

Thanks, that worked. There are no dates associated with this data, it is a static table.

Thanks

for your help..

Are you able to halp with another query too please?

http://community.qlik.com/message/172385#172385

thanks

Chris