topic Re: Line Chart expressions with 2 dimensions in QlikView

Line Chart expressions with 2 dimensions

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

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.

Re: Line Chart expressions with 2 dimensions

jyothish8807 — Mon, 01 Apr 2019 09:11:44 GMT

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.

Re: Line Chart expressions with 2 dimensions

jyothish8807 — Mon, 01 Apr 2019 10:13:04 GMT

Check this:

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

Re: Line Chart expressions with 2 dimensions

Yuhka — Tue, 02 Apr 2019 05:45:07 GMT

Hi @jyothish8807 ,

It worked well!!

Thank you for your help!

Re: Line Chart expressions with 2 dimensions

jyothish8807 — Tue, 02 Apr 2019 06:09:46 GMT

You are welcome