Unwanted Data

[#1]

hello, Someone please help me how to remove unwanted data

thanks

venky

[Anonymous]

On the dimensions of your charts make sure you have Suppress When Value is Null ticked.

[swuehl]

Seems like some of your facts you are aggregating are not properly linked to your calendar.

[sunny_talwar · Accepted solution]

Some of the date information may be missing/blank. You can remove them in the script by using where statement or you can use 'Suppress When Value Is Null' on the dimensions tab to remove it from the chart.

[#5]

Thanks folks...

I have another question...

What difference between

Gross sales, Net sales, Sales,

Thanks

Venkat

[sunny_talwar]

Gross Sales: Gross Sales Definition | Investopedia

Net Sales: Net Sales Definition | Investopedia

Sales: Sale Definition | Investopedia

HTH

Best,

Sunny

[sunny_talwar]

Gross Sales = Sales - Sales Returns

Net Sales = Gross Sales - All Other expenses (incl. wages, salaries, taxes, SG&A etc)

Sales = is before any deductions

HTH

Best,

Sunny

[#8]

How to avoid Null/Blank values in data model...

example:

MasterCalendar:

Right Keep (Orders)

LOAD

     OrderDate,

     Week,

     Year,

     Month,

     MonthNo,

     DayofYear,

     MonthYear,

     YearMonth,

     Day,

     Quarter,

     YearWeek,

     WeekDay,

     WeekDayNo,

     WeekInMonth,

     CurYTDFlag,

     LastYTDFlag,

     CurMTDFlag,

     LastMTDFlag

FROM

[$(vQvdPath)MasterCalendar.qvd]

(qvd) Where Year>=($(vMaxYear)-2);

Even i am Getting Null/Blank vales???

sunindia‌

[#9]

How to avoid Null/Blank values in data model...

example:

MasterCalendar:

Right Keep (Orders)

LOAD

     OrderDate,

     Week,

     Year,

     Month,

     MonthNo,

     DayofYear,

     MonthYear,

     YearMonth,

     Day,

     Quarter,

     YearWeek,

     WeekDay,

     WeekDayNo,

     WeekInMonth,

     CurYTDFlag,

     LastYTDFlag,

     CurMTDFlag,

     LastMTDFlag

FROM

[$(vQvdPath)MasterCalendar.qvd]

(qvd) Where Year>=($(vMaxYear)-2);

Even i am Getting Null/Blank vales???

[sunny_talwar]

Try this may be:

MasterCalendar:

Right Keep (Orders)

LOAD

    OrderDate,

    Week,

    Year,

    Month,

    MonthNo,

    DayofYear,

    MonthYear,

    YearMonth,

    Day,

    Quarter,

    YearWeek,

    WeekDay,

    WeekDayNo,

    WeekInMonth,

    CurYTDFlag,

    LastYTDFlag,

    CurMTDFlag,

    LastMTDFlag

FROM

[$(vQvdPath)MasterCalendar.qvd]

(qvd) Where Year>=($(vMaxYear)-2) and Len(Trim(OrderDate)) > 0 and Len(Trim(Year)) > 0 and Len(Trim(Month)) > 0;