Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

binitsingh
New Contributor

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
New Contributor III

Re: Filter in Pivottable

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.
Employee
Employee

Re: Filter in Pivottable

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

Thx

Employee
Employee

Re: Filter in Pivottable

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.