Hi guys!
I'm new to Qlik and I'm facing issues with getting the count for a set analysis expression.
This is my sample dataset
| b | 6/1/2019 0:00 | 23 |
| b | 6/1/2019 0:01 | 12 |
| b | 6/1/2019 0:02 | 32 |
| b | 6/1/2019 0:03 | 45 |
| b | 6/1/2019 0:04 | 65 |
| b | 6/1/2019 0:05 | 34 |
| b | 6/1/2019 0:06 | 76 |
| b | 6/1/2019 0:07 | 27 |
| b | 6/1/2019 0:08 | 12 |
| b | 6/1/2019 0:09 | 32 |
| b | 6/1/2019 0:10 | 14 |
Sheet 1
Sheet 2.
I have to produce the count of violation of the element b
My output is to find the number of counts of the values for the given Period (in the format 'M/D/YYYY hh:mm') going below (LL) or above (HL) for a continuous period of every 10minutes
This is my set analysis expression and i'm not sure if the logic is right!
Count({<value= {"<$(ll)- interval#(10,'mm'))>=$(hl)"}>}Period)
Is there any expression to get the right output?
.png "Former Employee"){kind=icon}
