Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@ysalvi43 - Try using Previous or Peek function. and you need to load the data using resident as you want total sum.
Hey @Rajashekar is it not possible to do calculation on Front end?