Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Calculations

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

Tags (2)
7 Replies
ecolomer
Honored Contributor II

Re: Calculations

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

NewSales = Sales * 1,1

Not applicable

Re: Calculations

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
Honored Contributor II

Re: Calculations

Probably you have some values NULL. Check this.

Re: Calculations

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

Peter

MVP
MVP

Re: Calculations

Hi Tom,

Try using an Aggregate function

=Sum([Order Qty])*1.1

Regards,

Jagan.

sakamsureshbabu
Contributor

Re: Calculations

you can post in qlik sense forum..

Not applicable

Re: Calculations

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