topic Need Help in Displaying data correctly in Pivot Table in QlikView

Need Help in Displaying data correctly in Pivot Table

Fri, 10 Jul 2009 13:52:28 GMT

Dear All,

I am creating a stock table for items

In that i am having column as Item Receipt (Qty) Issue(Qty) Diff(Qty)

Selection Parameters as Item/Year/Month/Day

Now for some items there may be null values for Receipt(Qty) or Issue(Qty)

what i wanted to show in Diff column is Receipt-Issue

Since some values are null it is not showing any value in Diff Column for those items

So i replaced null values with number 0

but even then also it is not showing any value in difference column

Note: For receipt(Qty) i am using expression only(Receipt Qty) and for issue qty am using only(Issue Qty)

for Diff i am using only(Receipt-Issue)

Can you guys please help me..

Need Help in Displaying data correctly in Pivot Table

Fri, 10 Jul 2009 16:50:22 GMT

"So i replaced null values with number 0"

How did you do this? - the chart has a setting (Presentation, Null Symbol) that allows you to specify what a null value is displayed as. If you changed this to '0' then the value is still null, even if it looks like '0'.

Check the use of the isnull( ) function and put it in your formula, i.e.

Diff = if( isnull( Receipt ), 0, Receipt) - if( isnull( Issue ), 0, Issue)

You might also consider using a mapping load in your load script to change the nulls to zero in your loaded data.

NullMap0:
MAPPING LOAD
null(), '0'
AUTOGENERATE 1;

MAP * USING NullMap0;
right join LOAD
*
resident Products;

Need Help in Displaying data correctly in Pivot Table

Fri, 10 Jul 2009 19:27:43 GMT

Have you tried using the options at the bottom left of the presentation tab, for "Suppress zero-values" and "Supress missing" ?