Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Greater than less than in Set Analysis

Hi,

I am not sure how to use greater than and less than in set analysis for the below condition - 

This is my table 

OrderNoWaiting daysResult
13Met
28Canceled 
36Met

Now i want to count the Orderno where waiting days is >=1 and Waiting Days is <=7 and Result is  not'Canceled'

 I have used : -

Count({$<[Waiting Days]={">=1<=7"},[Results]-={'Cancelled'}>} OrderNo)

This is wrong and not giving right output. Could someone guide me what is the best way to write this set analysis ?

 

Thanks in advance!

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

The way you are trying seems to be fine. Just try correcting your field name and value like highlighted in red below:

Count({$<[Waiting Days]={">=1<=7"},[Results]-={'Cancelled'}>} OrderNo)

View solution in original post

5 Replies
Highlighted
MVP
MVP

The way you are trying seems to be fine. Just try correcting your field name and value like highlighted in red below:

Count({$<[Waiting Days]={">=1<=7"},[Results]-={'Cancelled'}>} OrderNo)

View solution in original post

Highlighted
Creator II
Creator II

Use this condition.

Count({<[Waiting days]={'>=1<=7'},Result-={'Canceled'}>}OrderNo)

Highlighted
Creator II
Creator II

I fixed the value and field names, its still the same.

 

Highlighted
Creator II
Creator II

No this does not produce any results. It showing blanks.

Highlighted
Creator II
Creator II

Sorry! The script you posted was right!

Thanks a lot.