Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
use set analysis. sum({<subgroup={'values'}>}margin)
Or to exclude sum({<subgroup-={'values'}>}margin)
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 )
Thanks for your help ! 🙂