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: 
Not applicable

Concat between 2 calander objects

Hey Guys, I'm new to Qlikview and come across a stumbling block (QlikView 10).

I have 2 calander objects (StartDate and EndDate) and when i select the dates I want to populat the current selections box with all the dates between the 2dates so that a standard table box is filtered (I tried using set Analysis on a Streight table but i need to format alot of columns so this does not give the desired result).

To get round this I am trying to create a trigger so when the end date is selected it will select and concat all of the dates between the StartDate and End Date.

The data i am working with is just a standard daily date (eg. 01/07/2012)

The code i have created so far is below. If you can help in any way i would be really grateful

= Concat(distinct(DailyRevenueDate),'|')      // this conactenates my date successfuklly so just need to add the between dates

= Concat(distinct({< DailyRevenueDate = {'>=$(=Date(StartDate))<=$(=Date(EndDate))'}>}),'|') // this code returns no results

Thanks for your help

0 Replies