topic Re: Error with the result of IF() used in script. in App Development

Error with the result of IF() used in script.

Neymar_Jr — Mon, 11 Sep 2017 05:48:54 GMT

Hi Guys,

I am using an if statement in statement which shows the wrong result.

The if statement that i have used is as follows -

if(x<z or y<z,'x or y< z',

if(x>z or y>z,'x or y> z','x or y = z')) as "xyzpap".

But when i use it to create a pie-chart -

1) "xyzpap" as Dimension

2) Sum(values).

It gives wrong values for 'x or y<z', 'x or y >z' and 'x or y = z'.

How do i tweak the expression to get the correct result?

shraddha_g — Mon, 11 Sep 2017 08:17:48 GMT

It doesn't seem any issue with expression you have used.

If possible share screenshots of what you have done or Sample app

Neymar_Jr — Mon, 11 Sep 2017 11:12:09 GMT

I got it...it was silly on my part to post it here

The difference in result of excel file and that of qlik was because in excel the value of x,y and z were rounded-off.

And that resulted in different results!

Cheers!

shraddha_g — Mon, 11 Sep 2017 11:14:39 GMT

That's Good!