topic Re: Set Anaysis expression logic not working in QlikView

Set Anaysis expression logic not working

Qliksense7 — Wed, 10 Jul 2019 06:15:15 GMT

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?

Re: Set Anaysis expression logic not working

jaibau1993 — Wed, 10 Jul 2019 06:52:56 GMT

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.

Re: Set Anaysis expression logic not working

Qliksense7 — Wed, 10 Jul 2019 06:57:52 GMT

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?

Re: Set Anaysis expression logic not working

jaibau1993 — Wed, 10 Jul 2019 07:32:09 GMT

Hi!

Take a look on the attached file where I suggest a solution.

Jaime.

Re: Set Anaysis expression logic not working

Qliksense7 — Wed, 10 Jul 2019 10:49:11 GMT

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?

Re: Set Anaysis expression logic not working

Brett_Bleess — Wed, 31 Jul 2019 21:40:49 GMT

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:

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Sorry I do not have anything better but hopefully this may help a bit more.

Regards,
Brett