topic Hiding a column in a pivot table when the values are missing in QlikView

Hiding a column in a pivot table when the values are missing

Sun, 27 Oct 2013 13:59:52 GMT

Hi,

How can I do to hide an expression in a pivot table if there is no value filled in?

I've tried by creating a variable vDisplayExpression = if(isnull(Expression), 0,1) and then putting in the Conditional of the expression vDisplayExpression = 1 but it doesn't work, it disappears even if there are values in cells.

Any help will be appreciated.

Thanks

Re: Hiding a column in a pivot table when the values are missing

Anonymous — Sun, 27 Oct 2013 14:34:34 GMT

Cristina

What is the expression ?

Best Regards, Bill

Re: Hiding a column in a pivot table when the values are missing

Sun, 27 Oct 2013 14:47:01 GMT

The expression is:

ACTUAL PRICES=(sum($(vAddedCost)) + sum($(vTotalPrice)))/Sum(TOTAL_QUANTITY)

where vAddedCost=GetFieldSelections(CR_COD_CURRENCY_SAP)&'_ADDED_COST (in our database we have the fields EUR_ADDED_COST, USD_ADDED_COST AND LOCAL_ADDED_COST, so, based on user currency selection, one of those free fields will be used in analysis).

and

vTotalPrice=GetFieldSelections(CR_COD_CURRENCY_SAP)&'_TOTAL_PRICE (same for Total Price)

Re: Hiding a column in a pivot table when the values are missing

fred_s — Wed, 30 Oct 2013 21:10:04 GMT

Tried this one?

(sum($(vAddedCost)) + sum($(vTotalPrice)))/Sum(TOTAL_QUANTITY) <> 0