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've the following data.
I need to count the Status for each block of IN and OUT, and find out the Max and Avg IN and OUT for each Car. Below is the example for Car 1. Each session is 0.5 day.
Is there anyway that i can count the status for each block in Qliksense?
Please help me as i cannot resolve this for a week already. Really appreciate the help or advise given.
@nich_olas how you are deciding the block?
Hi Kush, based on the status change, from IN to OUT or OUT to IN. Based on the example, there are 3 blocks of IN and 3 blocks of OUT.
im looking at Rangesum, but not really sure how to use it. Especially when to stop the count and reset it to zero in order to start next block.
@nich_olas Would you be able to share sample data?
Check if this works -
Attached is the sample data. Really hope that you can help. Thank you.
Hi Neymar_Jr, thanks for the replied. The formula doesn’t work. The value will not be the expected result after first block. Please see the result below based on my example. (Sorry that I reply using my phone)
OUT-2 (from here onward the value is wrong)