topic Re: NaN value in KPI in App Development

NaN value in KPI

ramya_grandhi — Mon, 24 Sep 2018 14:11:31 GMT

Hi Everyone,

While I am trying to calculate the Gross Profit% I am getting NaN as a value in KPI in Qlik Sense Desktop. Anyone please suggest me how to resolve this.

Thanks in Advance.

Re: NaN value in KPI

timpoismans — Mon, 24 Sep 2018 14:26:54 GMT

Please give us more info on what measure you are using, the data you have. Or give us a sample app with dummy data.

Re: NaN value in KPI

rubenmarin — Mon, 24 Sep 2018 14:27:11 GMT

Hi Ramya, probably the second part of division is not being evaluated, and can't do a division by zero or null(), try setting the denominator in a separated expression to check the value returned.

Re: NaN value in KPI

ramya_grandhi — Tue, 25 Sep 2018 14:32:11 GMT

Hi Marin,

I found that denominator is giving 0. My requirement is to create a new dashboard with the given qvf (Generated for ID-10) but I need to change one filter condition (ID-20) in data load script. After changing the filter condition and reloading the data I am getting all 0 values in the dashboard.

I am wondering why is this happen because the same dashboard worked well for ID-10 but when I changed the condition it is giving me zero's in all the calculations

Re: NaN value in KPI

timpoismans — Tue, 25 Sep 2018 14:42:48 GMT

Most likely this would indicate that there's an issue with the data associated with ID-20 (or the filter).

But it's hard to say without having an example application.