Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ysalvi43
Contributor
Contributor

Expression_Calculation

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 

 

 

Labels (2)
2 Replies
Rajashekar
Contributor III
Contributor III

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

ysalvi43
Contributor
Contributor
Author

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