Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
mparker123
Contributor

One Dimensions and two expressions in a line chart

Good Afternoon,

I am trying to build a line graph that contains one dimension and two expressions. However, when i do this it only plots one line correct (see attached for picture). Is this something that is possible and if so what am i doing wrong to make one of the lines not working properly?

Dimensions:

Month

Expression:

Count({<DEPT={"44840"}>}Distinct Full_Name) for "# of Resources"

Count({<DEPT={"44840"}>}epic_summary) for "# of Projects"

1 Solution

Accepted Solutions
sergio0592
Valued Contributor II

Re: One Dimensions and two expressions in a line chart

Hi, i think it's a scale problem between your two expressions. So try to use double scale., left axis for "# of Resources and right axis for # of projects.

Scale.jpg

View solution in original post

1 Reply
sergio0592
Valued Contributor II

Re: One Dimensions and two expressions in a line chart

Hi, i think it's a scale problem between your two expressions. So try to use double scale., left axis for "# of Resources and right axis for # of projects.

Scale.jpg

View solution in original post