Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
marta2019_1
Contributor
Contributor

target & margin

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 ? 

 

1 Solution

Accepted Solutions
bramkn
Partner - Specialist
Partner - Specialist

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

View solution in original post

5 Replies
bramkn
Partner - Specialist
Partner - Specialist

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

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

marta2019_1
Contributor
Contributor
Author

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 )

agigliotti
Partner - Champion
Partner - Champion

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

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

Thanks for your help ! 🙂