topic Re: Set Expression in QlikView

Set Expression

md_qlikview — Wed, 15 Jul 2015 08:16:02 GMT

Hello All,

I want to calculate sales done by a managers on a given time period. Currently I am getting rolled up values in which his subordinate values are also getting included who are at different levels below respective managers eg. Level 2-4. How do I exclude his subordinates values from total of managers sales who are at level one? Is there any way to do this using set expression?

Thanks In Advance

Re: Set Expression

robert_mika — Wed, 15 Jul 2015 08:18:22 GMT

Could you post sample data?

Re: Set Expression

Gysbert_Wassenaar — Wed, 15 Jul 2015 08:19:09 GMT

Your question can't be answered without more information about your data model. Can you post a small qlikview document that demonstrates the problem? See this document: Preparing examples for Upload - Reduction and Data Scrambling

Re: Set Expression

md_qlikview — Wed, 15 Jul 2015 08:24:53 GMT

Sure. Lemme see what I can do