Expression_Calculation

[ysalvi43]

Hello Team,

is it possible to do below calculation on qliksense??

I have one column in which there are :

Chocolate

Icecream

Candy

I have used pivot table on qliksense and want to do calculate value dimension which does not exist in column and formula for Value is (chocolate - Icecream)/ sum( of everything) attaching calculation for your reference.

	Cost	Number
Chocolate	10	5
Icecream	20	9
Candy	30	15
Value	-0.17	-0.14

Thanks and regards 

[Rajashekar]

@ysalvi43  - Try using Previous or Peek function. and you need to load the data using resident as you want total sum.

[ysalvi43]

Hey @Rajashekar  is it not possible to do calculation on Front end?