Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
qliker3
Creator
Creator

Show data in a diagram from selection onwards

Hi,

I have a diagram with "date" as one of the dimentions.  Additionally i have a filter with DateFrom (the copy of the date column). I want to pick a date from and show dates from this filter and onwards in the diagram. For this i have written this expression 

=if(Date([TableD.Date], 'DD.MM.YYYY')>GetFieldSelections(Date(TableD.DateFrom, 'DD.MM.YYYY')), Date([TableD.Date], 'DD.MM.YYYY'))

why doesnt this work? And how can i fix it? 

Thanks 

20 Replies
ogster1974
Partner - Master II
Partner - Master II

Date should be a column, Datefrom you're using for your selection should be a column in a data island.

Date Fields should be in separate unlinked tables.

dimension for your chart should be the Date field the filter on your date should be the Datefrom field.

I can't give any more help than that.

Good luck.