Skip to main content
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
Showing results for 
Search instead for 
Did you mean: 
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
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.
Former Employee
Former Employee

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



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.