topic target & margin in QlikView

target & margin

marta2019_1 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

I'm trying to set up sales with target. As per my attachment the blue column is sales and the red one is target. As you can see the blue line is bigger than my target because some of the sub groups from my sales report is generating the wrong margin. I have a list of the sub groups i don't want to have included in Qlik. How to write a script for this ?

Re: target & margin

bramkn — Wed, 23 Jan 2019 10:46:02 GMT

use set analysis. sum({<subgroup={'values'}>}margin)

Or to exclude sum({<subgroup-={'values'}>}margin)

Re: target & margin

marta2019_1 — Wed, 23 Jan 2019 10:58:12 GMT

Hi there,

Thanks for your replay. Please see my script. Sorry I'm still doing something wrong as my sales column is zero value now but the target column seems fine. Would you know how can i fix this please?

Sum({ <SubGroup={'Bil, Dep, Pro, Misc, Top'} > } Margin )

Re: target & margin

agigliotti — Wed, 23 Jan 2019 11:00:50 GMT

you have to use the following syntax:
Sum( {< SubGroup = {'Bil','Dep','Pro','Misc','Top'} > } Margin )
Regards

Re: target & margin

bramkn — Wed, 23 Jan 2019 11:04:29 GMT

Keep in mind this will include the subgroups listed. To exclude change the "=" to "-="

Re: target & margin

marta2019_1 — Wed, 23 Jan 2019 11:46:09 GMT

Thanks for your help ! 🙂