Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to add the reference line that changes overtime?

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.

3 Replies
Highlighted

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

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%
];
Highlighted
Contributor
Contributor

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

reply is quite helpful.

Try this . it works.

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

Highlighted
Contributor
Contributor

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

reply is quite helpful.

Try this . it works.

Thank you  the person replying in this thread.

quite helpful.