Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mwalter_yopeso
New Contributor III

Complex formulas in Qliksense

Hi everybody,

im planning to do a new project which has much more complicated formulas that the ones I used in qliksense before.  I attached a sample:

My question is, can qliksense perform this kind of calculations accurately and performantly?

And if so: how can i implement the Sum-operator (∑)?

Thank you very much.

4 Replies
MVP
MVP

Re: Complex formulas in Qliksense

I think it should be possible... the sum-operator can be a dimension which goes from 1 to 5152.... It might be easier to do this with an example... but I feel that this is def. doable but will require some time and patience.

mwalter_yopeso
New Contributor III

Re: Complex formulas in Qliksense

Thank you for your quick answer. But what do you mean with "the sum-operator can be a dimension"? can you give me quick codeexample on how this would look like?

I myself cant provide an example right now, its just in the stage of looking which software might be suitable for this project

MVP
MVP

Re: Complex formulas in Qliksense

I can try, but won't really know if the output is what you need... but is this something you need in the script?

beck110979
Valued Contributor III

Re: Complex formulas in Qliksense

Hi Matthias,

check this e ‒ QlikView

and you can with help of variable create this expression

i hope that helps

Beck

Community Browser