topic Re: How to Divide values in Qlikview in QlikView

How to Divide values in Qlikview

Tue, 30 Jun 2015 08:49:35 GMT

Hi,

how does one divide values in Front End

e.g

Im sitting with:

VALUE 500 I need to see 50% of that Value which is 500 / 2

so i need a sample sum Script that can Occupy this.

Thanks

Re: How to Divide values in Qlikview

alexandros17 — Tue, 30 Jun 2015 08:55:20 GMT

Are you using an expression?

If yes then Sum(Values) / 2

Re: How to Divide values in Qlikview

Tue, 30 Jun 2015 08:58:14 GMT

Hi Saccone,

so now if the column im calculating contains Nulls and want to Add the Values on from a Different Field, how to Accomodate that?

Thanks.

Re: How to Divide values in Qlikview

alexandros17 — Tue, 30 Jun 2015 09:13:11 GMT

It should be:

(Sum(Field1) + Sum(Field2)) / 2

Re: How to Divide values in Qlikview

SatyaPaleti — Tue, 30 Jun 2015 09:54:42 GMT

Hi Alessandro,

Try this

=Div(Valuee,2)

Thank you,

SatyaPaleti

Re: How to Divide values in Qlikview

Tue, 30 Jun 2015 10:10:59 GMT

HI Guys,

this has to ignore all the Existing values only put in the new ones where we had nulls, because if i add the script to the current column it will divide existing numbers, so i don't want that

Thanks.