Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Multiplication inside Sum with Total

I'm trying to create a function that is essentially:

SUM(colA * colB * Total ColC)

But it's returning nothing.

The actual expression is a little more complicated:

If(Sum(count) <> 0, Sum([Number of Tickets]),

Sum([curves.curve]*[OP.tixrsrperc]*

TOTAL {<[OP.week_ending_date] = {"$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>}count

/

TOTAL {<[OP.week_ending_date] = {"$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>}[curves.curve]

)

)

I verified all the individual parts work as expected.  Any ideas?

1 Reply

Re: Multiplication inside Sum with Total

May be this

Sum(Aggr(

Sum([curves.curve])*Sum([OP.tixrsrperc]) *

Sum(TOTAL {<[OP.week_ending_date] = {"$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>} count)

/

Sum(TOTAL {<[OP.week_ending_date] = {"$(='>=' & Date(Max({<count = {'*'}>}[OP.week_ending_date], 4)) & '<=' & Date(Max({<count = {'*'}>}[OP.week_ending_date])))"}>}[curves.curve]), UniqueIdentifierField))

Community Browser