topic Re: Data are not visible in certain cases in QlikView

Data are not visible in certain cases

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

Please help me on this

By linking couple of different tables, I have done a graph (pie chart). When everything is cleared, data are shown in the Graph. Also in certain centers data are available but in some centers, it looks blank but of course data are available & are shown in the pivot table only it is not visible in the chart. What could be the case for this. Any easy access to locate the error

Thanks

Neville

Re: Data are not visible in certain cases

dplr-rn — Wed, 12 Sep 2018 17:22:53 GMT

are there negative values?

Re: Data are not visible in certain cases

nevilledhamsiri — Wed, 12 Sep 2018 17:40:39 GMT

Not really remember. Why is it something really causing this? if so what is the solution?

Re: Data are not visible in certain cases

dplr-rn — Wed, 12 Sep 2018 17:42:53 GMT

negatives cannot be handled in pie charts.it fails

hence the question. would need more details or example to help further i feel

Re: Data are not visible in certain cases

nevilledhamsiri — Wed, 12 Sep 2018 17:50:59 GMT

Dear Dilip,

Will send you the sample probably tomorrow which data are left in office for further analysis. This is the premium composition by various products which were assigned the ratios based on the total

Thanks

Neville

Re: Data are not visible in certain cases

dplr-rn — Wed, 12 Sep 2018 17:56:28 GMT

Sure..

use the same expression as the pie chart in a straight table or pivot to compare.

If data is the issue - in some cases need to identify the records causing issue and analyse that to get to results