Qlik Community

App Development

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

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Naresh1
Contributor III
Contributor III

positive, negative and greater than values

Hi,

I have Lot of fields in qliksense table,  using two fields in qliksense table those are outstanding amount and original amount,  some values are common in these two fields, my client given some conditions for these two fields

 1. Original Amount  = Outstanding  Amount (Positive Amount)
2. If Outstanding  Amount is Less than Original Amount (Positive amount)                                                                                            3. If Outstanding  Amount  is greater than or Equal To Original Amount (Negative amount)

all these conditions should come in qliksense table order wise, how can i do this?

its urgent

Thanks

 

2 Replies
TimvB
Creator II
Creator II

Set in the sort section of the Table the sort function to "Expression" and paste the following sort function:

if([Original Amount] = [Outstanding Amount],
	'1',
	If([Original Amount] > [Outstanding Amount],
		'2','3'
))

 

You can do this in the script as well and use the function Dual instead.

Naresh1
Contributor III
Contributor III
Author

Hi, 

See the below sample data 

And also I'm given conditions, 

I want to do all the conditions in Qliksense table, 

See 4 conditions, 

I want all 4 conditions values should come order by, 

Thanks for responding