Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Element | LL | HL |
b | 20 | 24 |
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?
Hi!
Could you please share your desired output? I can not understand what you actually want. Do you want the count of values greater than HL or lower to LL every ten minutes? Do you want it in a text box or in a chart?
On the other hand, your set expression is wroing for sure, I do not recognize a correct syntax there.
Regards,
Jaime.
Hi @jaibau1993 ,
I'm sorry for not being clear,
So lets say for just LL .
If all my values for 10minutes period are less than LL (all values less than 20) then my count = 1 or for that 10minutes period my count = 0.( if its had 20, 30 or like that )
How to produce a count for the given condition?
Hi!
Take a look on the attached file where I suggest a solution.
Jaime.
Hey @jaibau1993 ,
I'm able to see the separate variables you have created can you tell me how to use those in a count expression?
Here are some links that might help you out at this point:
Design Blog:
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
Help:
Sorry I do not have anything better but hopefully this may help a bit more.
Regards,
Brett