topic Line chart with nulls in QlikView

Line chart with nulls

nakuldev — Thu, 26 Apr 2018 12:01:41 GMT

Hi,

In line chart while showing values I am getting all the countries data but while trying to populate same in %, country Malaysia is getting missed. I figured out that the issue is due to JOIN. I have joined Forex table to CPI table. CPI table have dates for Malaysia starting from 2003 where Forex table have dates from 2015. I tried with link table, composite keys and tried many ways and could not achieve it. Could someone help me with this issue.

Please find the attached demo.

Re: Line chart with nulls

sunny_talwar — Thu, 26 Apr 2018 12:47:39 GMT

Try this

1/(Sum( Exchange_Rate)/FirstSortedValue({<Exchange_Rate = {"*"}>}DISTINCT TOTAL <Index_Country> Exchange_Rate,CPIFX_Date))

Re: Line chart with nulls

nakuldev — Fri, 27 Apr 2018 05:57:34 GMT

Thank you Sunny! You are pretty awesome in solving such issues.