topic Re: How to add the reference line that changes overtime? in QlikView

How to add the reference line that changes overtime?

Marie201931 — Wed, 25 Nov 2020 16:16:04 GMT

The dimension is project released month from 09/2018 to 01/2019.

My target is 09/2018: 66%; 10/2018: 99%; 11/2018: 100%; 12/2018: 100%; 01/2019: 100%.

I wrote a load * inline statement to insert two more column in my data. But the target number is not showing in my final table at all.

Table1:
LOAD

ID,

Name,
[Project Development Release Month]
FROM a location
(qvd);
left join(Table1)
load * inline
[Project Development Release Month, Target
09/2018,66%
10/2018,100%
11/2018,100%
12/2018,100%
01/2019,100%];

Thanks for your help.

Re: How to add the reference line that changes overtime?

sunny_talwar — Fri, 22 Mar 2019 15:40:19 GMT

The field type for Project Development Release Month in the two tables might not be the same. It might be a Date field within Table1, but Text within the inline load.... may be try this

Table1:
LOAD ID,
  Name,
  [Project Development Release Month]
FROM a location (qvd);

Left Join(Table1)
LOAD Date#([Project Development Release Month], 'MM/YYYY') as [Project Development Release Month],
Target;
LOAD * INLINE [
Project Development Release Month, Target
09/2018,66%
10/2018,100%
11/2018,100%
12/2018,100%
01/2019,100%
];

Re: How to add the reference line that changes overtime?

petersmith69 — Fri, 22 Mar 2019 22:12:21 GMT

reply is quite helpful.

Try this . it works.

Thank you the person replying in this thread.quite helpful.

Re: How to add the reference line that changes overtime?

petersmith69 — Fri, 22 Mar 2019 22:13:20 GMT

reply is quite helpful.

Try this . it works.

Thank you the person replying in this thread.

quite helpful.