Filter in Pivottable

[binitsingh]

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

[NhanNguyen]

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]

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

Thx

[Joe_DosSantos]

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.