Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Yuhka
New Contributor III

Line Chart expressions with 2 dimensions

 

Hello guys, I'm new to Qlikview.

 I have a data which has fields (No, Reception Date, Completion Date),  and I would like to express a transit graph with 2 dimensions (Reception Date, Completion Date) to count the numbers for each month.

  • months are taken in horizontal axes

  • express zero-valuesdata.PNG

 

Currently I created two graph for each date dimentions as below.

キャプチャ2.PNG

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Is it possible to express 2 dimensions in a graph?

Thank you for your support.

1 Solution

Accepted Solutions
jyothish8807
Honored Contributor II

Re: Line Chart expressions with 2 dimensions

Hi Yukha,

Two possible ways to do this:

1. Create a Master Calendar with all possible dates you want and keep it as independent table (Not connected to your data model)  , then use date field from master calendar as Dimension.

Expression1: count({<Date=p(Reception Date)>}No)

Expression2: count({<Date=p(Completion Date)>}No)

 

2, Second way would be to create a link table and name both "Reception" and "Completion Date" as a common date field and link it to Master calendar also add some flags to identify them.

Best Regards,
KC
4 Replies
jyothish8807
Honored Contributor II

Re: Line Chart expressions with 2 dimensions

Hi Yukha,

Two possible ways to do this:

1. Create a Master Calendar with all possible dates you want and keep it as independent table (Not connected to your data model)  , then use date field from master calendar as Dimension.

Expression1: count({<Date=p(Reception Date)>}No)

Expression2: count({<Date=p(Completion Date)>}No)

 

2, Second way would be to create a link table and name both "Reception" and "Completion Date" as a common date field and link it to Master calendar also add some flags to identify them.

Best Regards,
KC
jyothish8807
Honored Contributor II

Re: Line Chart expressions with 2 dimensions

Check this:

You can get the complete script and logic for master calendar, this just a sample

 

Best Regards,
KC
Yuhka
New Contributor III

Re: Line Chart expressions with 2 dimensions

Hi @jyothish8807 ,  

It worked well!!Smiley LOL

Thank you for your help!

jyothish8807
Honored Contributor II

Re: Line Chart expressions with 2 dimensions

You are welcome

Best Regards,
KC