topic Re: Multiple of a value in QlikView

Multiple of a value

jakobjosef — Thu, 20 Sep 2018 08:15:36 GMT

Hi dear Community,

I want to show Sum of Sales, if Sales are made by group nr. 5 or a multiple of group nr. 5, live 15, 25 or 45.

My expression should look like this:

if( GroupNr. = 5 or a multiple of 5, Sum(Sales))

maybe it is close to: if( GroupNr. = 5 or Group Nr. 5*x , Sum(Sales))

So if Group Nr. 10, 15 and 65 made sales, those should get summed up.

Is there any set analysis or function for my problem?

Thank you very much

Jakob

rajivmeher — Thu, 20 Sep 2018 08:33:48 GMT

Hi Jakob

Please see if the below would work?

IF(MOD(GroupNr, 5) = 0, SUM(Sales))

Regards

Rajiv.

Peter_Cammaert — Thu, 20 Sep 2018 09:08:58 GMT

If GroupNr is a dimension in your chart, then you can use Rajivs solution.

If GroupNr is not a dimension, then you can try with:

=Sum(IF (Mod(GroupNr, 5)=0, Sales)) // Slow

=Sum({<GroupNr*={$(=Concat(DISTINCT IF(Mod(GroupNr, 5)=0, GroupNr), ','))}>} Sales) // Fast

MarcoWedel — Thu, 20 Sep 2018 22:01:08 GMT

another possible expression:

Sum({$<GroupNr={"=not Mod(GroupNr,5)"}>} Sales)

hope this helps

regards

Marco

jakobjosef — Mon, 24 Sep 2018 05:58:58 GMT

Hi Rajiv, Peter and Marco,

thank you very much for your help, with your hints I was able so solve my problem.

Have a nice day,
Jakob

MarcoWedel — Wed, 26 Sep 2018 20:01:49 GMT

Hi,

glad it helped.

Can you please post your solution?

thanks

regards

Marco