topic Re: Where year>2017 in App Development

Where year>2017

W4ld — Fri, 07 Jun 2019 12:14:40 GMT

Hi,

this is my first question I'm posting here, I hope I don't make to many mistakes.

In my script, I LOAD data from a qvd, that another app programed by somebody else made from multiple csv. That works pretty good, but now I tried to put a where-clause in my load statement, in order to only load real data and not the fake test data. To do so, I say where(yearmonth>201699)

According to my understanding, this should give me all the data from the year 2017 and onwards. However I discovered, that the year 2016 still is in my Dashboards, it just doesn't contain data anymore. I had the same result when trying to exclude 2017 the same way, that year contains real data. Since the point of this is reduce potential misunderstandings for people who use my app and don't have any knowledge of the programming, this doesn't rly get me there.

What did I do wrong or is there another possibility to completely exclude all data from before 2017?

Thanks in advance and greetings from Germany!

Re: Where year>2017

sunny_talwar — Fri, 07 Jun 2019 12:18:10 GMT

What is the exact script you are using?

Re: Where year>2017

marcus_sommer — Fri, 07 Jun 2019 14:48:39 GMT

Beside filtering your fact-data you might also need to filter your dimension-data (calendar).

- Marcus

Re: Where year>2017

W4ld — Tue, 11 Jun 2019 10:21:02 GMT

name:
LOAD
yearmonth
year('01.'&right(yearmonth,2)&'.'&left(yearmonth, 4)) as year,
month('01.'&right(yearmonth,2)&'.'&left(yearmonth, 4)) as month,
data

FROM [lib://QVD/Datasource\name2.qvd]
(qvd);

Thats the (simplified) script right now.

Re: Where year>2017

W4ld — Tue, 11 Jun 2019 10:23:51 GMT

I haven't had the time yet to get into the calendar-stuff, so everything there is in default mode right now. Would you mind elaborating?

Re: Where year>2017

sunny_talwar — Tue, 11 Jun 2019 10:24:05 GMT

How about this?

name: LOAD yearmonth year('01.'&right(yearmonth,2)&'.'&left(yearmonth, 4)) as year, month('01.'&right(yearmonth,2)&'.'&left(yearmonth, 4)) as month, data FROM [lib://QVD/Datasource\name2.qvd] (qvd) Where Left(yearmonth, 4) > 2017;

Re: Where year>2017

W4ld — Tue, 11 Jun 2019 10:40:46 GMT

I figured it out, my solution and also yours works perfectly, the problem was other data, that shared fields with my data and that I hadn't used the where-command on.
So in case somebody else reads this and has a similar problem:
Use the where-clause on all data, that is connected to the data you want to filter.