Calculations

[#1]

Hi All

I am very new to Qlik Sense, it is an awesome bit of kit though

I have one quick question I would like to ask

I am trying to use it for some forecasting, so I currently have my graph with month by month sales

I would like to see month by month sales with 10% added on to the totals

Is this something that can be done within the editor of Qlik sense or is it something that needs to be done on the outside in excel and imported into Sense?

Any help would be most greatful

Kind Regards

Tom

[ecolomer]

You can put the sales month by month multiply by 1,1

NewSales = Sales * 1,1

[#3]

Thanks for the reply, I seem to be having a slight issue with writing the sum in Qlik Sense, below is what I have used but it seems to change all the values to 1.1 rather than multiply them

([Order Qty]*1.1)

[ecolomer]

Probably you have some values NULL. Check this.

[Peter_Cammaert]

This is a QlikView forum. Please move your discussion to "New in Qlik Sense". That may help in getting you more feedback.

Peter

[jagan]

Hi Tom,

Try using an Aggregate function

=Sum([Order Qty])*1.1

Regards,

Jagan.

[sakamsureshbabu]

you can post in qlik sense forum..

[#8]

Maybe the Order Quantity is 1 most of the time and thus 1.1 for your calculated field. Try doing it like Enrique suggested above, i.e. multiplying sales by 1.1.

//Pedro