Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
binitsingh
Contributor II
Contributor II

Filter in Pivottable

Hi All,

I want  to put filter in Pivot table. I have the data where as i required where the value is more than >1000 and >-1000 that particular row should be displayed in pivot table rest row not required. i used below expression but not able to filter the data

=sum({$<[Variance classificaion]={'UP','UAP'>} [Far value difference])

+sum({$<[Variance classificaion]={'UP','UAP'>} [booked price]).

Need help.

Its urgent

Thanks in advance,

Binit Singh

Labels (1)
3 Replies
NhanNguyen
Contributor III
Contributor III

The function you wrote should give you a value not doing any filter. I think you could try:
if(value >1000, Value,0)
and make sure to tick "Suppress 0", so that 0 will not be shown in the table.
Peter_Kim
Former Employee
Former Employee

Are you sure this is a Data Catalyst question and not Qlik Sense? 

Thx

Joe_DosSantos
Employee
Employee

Hello. Are you in the Qlik Data Catalyst application or is this a QlikSense/QlikView question? I am concerned that this community may not know the answer to this question if it is related to QlikSense.