Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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