Pivot table - show data only on condition

[#1]

Hi,

I have a pivot table that contains several columns and I want to reduce the amount of displayed data (rows) by using an existing 'Status' field. Status shall be 'Active' only and this field shall not be displayed, How can I achieve this?

Thanks, Regards,

Jens

[qlikpahadi07]

check this and see report Tab might help you

QlikView

[israrkhan]

Hi Jens

what are your dimensions and expressions:

i think it is possible with Calculated Dimension, or if you change to straight table Dimension Limits Tab.

Khan

[Clever_Anjos]

at each expression add a Set Analysis expression

{<Status="Active">}