topic Re: Sum in QlikView

Sum

gautik92 — Wed, 03 Feb 2016 07:53:27 GMT

I have a product List in that i have sub category

if i have sum(sales) for that sub category its showing values for -

but i don have sub cat name as - in the products

if i take sub cat in list box - is not showing but if i take sum(sales) its showing sales for -

Wed, 03 Feb 2016 08:01:08 GMT

the '-' represents null values. In your data model, you must have values for Actual that don't have a corresponding SubCatName (null)

settu_periasamy — Wed, 03 Feb 2016 08:01:36 GMT

Hi,

Generally Null value won't dispaly in the ListBox..

In your chart, Suppress the Null value in your Dimension..

jagan — Wed, 03 Feb 2016 08:18:22 GMT

Hi,

That - is a null value, null value is not displayed in the List object. If you want to display some value for try like below

LOAD

If(Len(Trim(FieldName)) = 0, 'NA', FieldName) AS FieldNameNew

FROM DataSource;

Now in place of null values it will display NA.

Regards,

jagan.