topic Re: Unwanted Data in QlikView

Unwanted Data

Mon, 29 Jun 2015 16:01:08 GMT

hello, Someone please help me how to remove unwanted data

thanks

venky

Re: Unwanted Data

Anonymous — Mon, 29 Jun 2015 16:02:51 GMT

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

Re: Unwanted Data

swuehl — Mon, 29 Jun 2015 16:03:25 GMT

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

Re: Unwanted Data

sunny_talwar — Mon, 29 Jun 2015 16:04:47 GMT

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.

Re: Unwanted Data

Mon, 29 Jun 2015 16:10:47 GMT

Thanks folks...

I have another question...

What difference between

Gross sales, Net sales, Sales,

Thanks

Venkat

Re: Unwanted Data

sunny_talwar — Mon, 29 Jun 2015 16:13:35 GMT

Gross Sales: Gross Sales Definition | Investopedia

Net Sales: Net Sales Definition | Investopedia

Sales: Sale Definition | Investopedia

HTH

Best,

Sunny

Re: Unwanted Data

sunny_talwar — Mon, 29 Jun 2015 16:16:48 GMT

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

Re: Unwanted Data

Mon, 29 Jun 2015 16:17:55 GMT

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‌

Re: Unwanted Data

Mon, 29 Jun 2015 16:18:57 GMT

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???

Re: Unwanted Data

sunny_talwar — Mon, 29 Jun 2015 16:20:41 GMT

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;

Re: Unwanted Data

Anonymous — Mon, 29 Jun 2015 16:21:14 GMT

Try deleting the Where condition:

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

Re: Unwanted Data

Mon, 29 Jun 2015 16:26:26 GMT

Same result..: (

Re: Unwanted Data

Mon, 29 Jun 2015 16:27:12 GMT

I need to load Recent 3 years data without Null/Blanks data..!!

Re: Unwanted Data

Mon, 29 Jun 2015 16:29:35 GMT

Even i am getting same problem while i am loading data for only Sales Representative...

Re: Unwanted Data

sunny_talwar — Mon, 29 Jun 2015 16:36:53 GMT

Venkat can you sharea reduced version your application or a sample to look at and see what is causing the trouble??

Re: Unwanted Data

Mon, 29 Jun 2015 16:50:36 GMT

Bro how to send Datamodel.qvw..?

I am new to community...sorry..

Re: Unwanted Data

sunny_talwar — Mon, 29 Jun 2015 16:53:12 GMT

You want to know how to attach the qvw?

Try this:

Step1:

Step2:

Re: Unwanted Data

Mon, 29 Jun 2015 17:07:29 GMT

I dont have "Use Advanced editor" tab

Re: Unwanted Data

sunny_talwar — Mon, 29 Jun 2015 17:08:35 GMT

When you click on reply, you don't see 'Use advanced editor' at the top right of your screen???

Re: Unwanted Data

Mon, 29 Jun 2015 17:15:41 GMT