Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

I have to hurry and finish it. Can you guys help me?

Sxbbb_0-1677137230279.png

Where 'With in spec' =   Value>=Min and Value <=Max.

 

Example 1 work order

Sxbbb_1-1677137340827.png

In each WorKOrder if "Value" must be between all "max and min" values.
It counts as 1 WorKOrder and is summed to all WorKOrders if "Value" must be between all 
"max and min" values.
Now I can do it like this which is wrong

Sxbbb_2-1677137628127.png

 

used code of  'With in spec'.

Count(Aggr(if(Value>=Min and Value <= Max,Count(WorkOrder),0),WorkOrder)) 

You can see more details from the thread I posted earlier.

 https://community.qlik.com/t5/QlikView-Administration/need-code-from-Value-gt-Min-and-Value-lt-Max/t...

 

I have to hurry and finish it. Can you guys help me?
1 Reply
Sxbbb
Creator III
Creator III
Author

The code I'm using is wrong.

 

Sxbbb_0-1677138217297.png