topic Re: Line chart filter selection in QlikView

Line chart filter selection

nakuldev — Thu, 19 Apr 2018 10:39:45 GMT

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

Re: Line chart filter selection

tresB — Thu, 19 Apr 2018 10:47:38 GMT

Try expression like:

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

Re: Line chart filter selection

nakuldev — Fri, 20 Apr 2018 05:37:06 GMT

Thank you very much Tresesco! It got worked.