Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Mark18
Contributor II
Contributor II

Linking two columns to same field

Hello guys,

I have a table with two different fields like start date and end date.  Another table which is the master calendar containing all the dates. I have to put a barchart with dimension months and the measure would be no of entries with start/end date in that month.

How can i do this?

Thanks in advance

Labels (1)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You will want to create a Date Link table that associates both dates with the master calendar.

Qlikview Cookbook: Tutorial - Using Common Date Dimensions https://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

 

-Rob