This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
i would like to select a customer and be able to see how many days go between the last sale and the previous one.
@Carlaf_93 I understood no need to do a set analysis.
for exampe :
if I selected A as customer :
So to calculate nbr of days u can use :
View solution in original post
Can you share with me how you calculate 33, because :
between 19/03 and 12/02 ->35 days
between 23/04 and 19/03 ->35 days
between 23/05 and 23/04 ->30 days
between 19/06 and 23/05 ->27 days
the avg thus is 31.75
And if i want the average number of days between all the sales of one customer?
can you share a sample data and the expected value of the avg ?
LOAD * INLINE [DATE_A, CUSTOMER, SALES,
12/02/2019, A, 3,
19/03/2019, A, 30,
23/04/2019, A, 7,23/05/2019, A, 7,
19/06/2019, A, 3,];
I expect an average of 33 days for customer A