Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ysalvi43
Contributor
Contributor
‎2022-10-07 04:15 AM

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)
Labels
Preview file
10 KB
726 Views
0 Likes
2 Replies
Rajashekar
Contributor III
Contributor III
‎2022-10-07 04:21 AM

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

721 Views
ysalvi43
Contributor
Contributor
‎2022-10-07 04:58 AM
Author

In response to Rajashekar

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

 

708 Views
0 Likes