topic Re: Hiding values in chart in QlikView

Hiding values in chart

hopkinsc — Mon, 20 Jun 2011 09:24:48 GMT

Hi, I am trying to hide some values within a straight table.

I have 2 straight tables:

Goods Received

Goods Returned

Goods receiving figures are all POSITIVE values and goods returned are all NEGATIVE values.

The problem i have is that the only way i can tell what is returned and what is received is by looking at the values.

I want to be able to show ONLY POSITIVE vales in the goods received table and ONLY NEGATIVE values in the goods returned table.

I have tried writing a simple expression for each table

i.e.

If(sum(StockQty)>0,StockQty)

StockQty is my value field.

But this still shows the details for the negative lines (but hides the actual value) is there a way i can completely hide the full line for negative values on Goods Receiving and hide the complete line for positive vales on the Goods Returned table?

I have attached a sample

Thanks for your help.

Chris

Re: Hiding values in chart

jonathandienst — Mon, 20 Jun 2011 09:42:16 GMT

Chris

Change the first expression in Goods Received to =Sum(If(StockQty > 0, StockQty)). Then filter the remaining expressions using =If(Column(1) <> 0, origExpression)). The row will only be suppressed if all the expressions return zero or null.

I have done this for the Goods Received table in your sample (attached).

Hope that helps

Jonathan

Re: Hiding values in chart

hopkinsc — Mon, 20 Jun 2011 09:57:22 GMT

Hi Jonathan,

Sorry, even though the negative lines are hidden, the sum expressions are still adding the negative values to the totals.

Above the [otal value] is 10 even though the line sais 11. It has added in the -1 line also.

Re: Hiding values in chart

kaushiknsolanki — Mon, 20 Jun 2011 10:10:22 GMT

Hi,

Here is your solution.

Regards,

Kaushik Solanki

Re: Hiding values in chart

jonathandienst — Mon, 20 Jun 2011 12:09:43 GMT

Chris

Try changing the totals to Sum of Rows on the expression tab

Regards

Jonathan