Line Chart expressions with 2 dimensions

[Yuhka]

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-values

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

Is it possible to express 2 dimensions in a graph?

Thank you for your support.

[jyothish8807 · Accepted solution]

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.

[jyothish8807]

Check this:

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

[Yuhka]

Hi @jyothish8807 ,  

It worked well!!

Thank you for your help!

[jyothish8807]

You are welcome