Line chart filter selection

[nakuldev]

Hi,

In the line chart, when we select date in the filters the chart will show data for that particular date. But my requirement is when we select one particular date the line chart should show data/line from the particular date selected to max date or recent date. Could someone help me with this.

Please find the attached QVW for reference.

Thanks

Nakul

[tresesco]

Try expression like:

Sum({<CPIDate={">=$(=Date(Min(CPIDate)))"}>}  CPI_Data)/FirstSortedValue(DISTINCT TOTAL <CPI_Country> {<CPIDate={">=$(=Date(Min(CPIDate)))"}>} CPI_Data,CPIDate)

[nakuldev]

Thank you very much Tresesco! It got worked.