topic Re: Pivot table - show data only on condition in QlikView

Pivot table - show data only on condition

Wed, 02 Oct 2013 10:20:51 GMT

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

Re: Pivot table - show data only on condition

qlikpahadi07 — Wed, 02 Oct 2013 10:24:44 GMT

check this and see report Tab might help you

QlikView

Re: Pivot table - show data only on condition

israrkhan — Wed, 02 Oct 2013 10:29:23 GMT

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

Re: Pivot table - show data only on condition

Clever_Anjos — Wed, 02 Oct 2013 11:29:43 GMT

at each expression add a Set Analysis expression

{<Status="Active">}