Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Qliksense7
Contributor II
Contributor II

Set Anaysis expression logic not working

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

b6/1/2019 0:0023
b6/1/2019 0:0112
b6/1/2019 0:0232
b6/1/2019 0:0345
b6/1/2019 0:0465
b6/1/2019 0:0534
b6/1/2019 0:0676
b6/1/2019 0:0727
b6/1/2019 0:0812
b6/1/2019 0:0932
b6/1/2019 0:1014

Sheet 1

ElementLLHL
b2024

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?

5 Replies
jaibau1993
Partner
Partner

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.

Qliksense7
Contributor II
Contributor II

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? 

jaibau1993
Partner
Partner

Hi!

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

Jaime.

Qliksense7
Contributor II
Contributor II

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? 

Brett_Bleess
Support (Former)
Support (Former)

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/S...

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

Regards,
Brett

 

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.