Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following table:
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
I think you need to add TOTAL<CustName> to your expressions, like
=max(total<CustName> Sequence)
Do you have only data for one week?
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