Show data in a diagram from selection onwards

[qliker3]

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 

[ogster1974]

but they cant be in the same table the datefrom field needs to be on its own in a data island for your solution to work.

At the moment selecting datefrom is filtering all your data including date down to just that selection cause its part of the same tableA dimension.

[qliker3]

i reverted the original chart and added one more chart but only with datafrom as dimension and Avg({$<[Table.Country]={"Germany"}, Date={">$(vMaxDate)"}>} $(anotherVar)) as measure. It still shows only one bar

[ogster1974]

make the dimension of your chart Date not date from.

[qliker3]

still no changes 

[ogster1974]

show me your data model is it linked in any way between Date Table and date from table.

[qliker3]

LOAD
DateKey,
Date(Floor(DateHour - MakeTime($(i))), 'DD.MM.YYYY hh:mm:ss') as Date,
Date(Floor(DateHour - MakeTime($(i))), 'DD.MM.YYYY hh:mm:ss') as DateFrom

[ogster1974]

You are joining the tables hence its filtering to the one date you select.  Don't include Date in the same table or date key in the same table as datefrom

Make a data island i.e. no link to other data.

LOAD
Date(Floor(DateHour - MakeTime($(i))), 'DD.MM.YYYY hh:mm:ss') as DateFrom

Then you can use it to set the date range independently of your transactional data.

[qliker3]

i removed date from the load script and only left datefrom, still only one bar in chart. 

[ogster1974]

I'm not sure I can be much more help I can't see what you are doing.  The solution I originally proposed will work if applied correctly and the data is modelled correctly.

[qliker3]

to summorize: Avg({$<[Table.Country]={"Germany"}, Date={">$(vMaxDate)"}>} $(anotherVar)) 

should it be Date or DateFrom? With Date (as a function, not column) it gives one bar. With DateFrom=... it gives undefined values