Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

7 Replies
ecolomer
Master II
Master II

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

NewSales = Sales * 1,1

Not applicable
Author

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
Master II
Master II

Probably you have some values NULL. Check this.

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

Peter

jagan
Luminary Alumni
Luminary Alumni

Hi Tom,

Try using an Aggregate function

=Sum([Order Qty])*1.1

Regards,

Jagan.

sakamsureshbabu
Creator
Creator

you can post in qlik sense forum..

Not applicable
Author

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