topic Re: Incentive calculation in QlikView

Incentive calculation

selcukcadir — Wed, 14 Oct 2020 17:11:15 GMT

Hi All,

I tried to explain my problem in the attachment.Can such a solution be produced?

your help please

Thanks in advance.

Re: Incentive calculation

Lisa_P — Wed, 14 Oct 2020 22:40:18 GMT

I don't understand the Set logic

Re: Incentive calculation

Kushal_Chawda — Wed, 14 Oct 2020 22:51:18 GMT

@selcukcadir does it not set 1 for COS 2?

Re: Incentive calculation

selcukcadir — Thu, 15 Oct 2020 05:26:03 GMT

Hi,

cos2 customer invoice is in group "inc1"

invoices COS2;

Re: Incentive calculation

selcukcadir — Thu, 15 Oct 2020 05:34:57 GMT

set groups are different and their quantities can be different

each inc group 1 set

inc1 for incentive ;

inc2 for incentive ;

Re: Incentive calculation

Kushal_Chawda — Thu, 15 Oct 2020 09:58:21 GMT

@selcukcadir how do you pick set 2 here?

Re: Incentive calculation

selcukcadir — Thu, 15 Oct 2020 10:57:49 GMT

@Kushal_Chawda I do not understand what you asked. I need the number of sets per incentive group. I want to see the set numbers by selecting the incentive groups.

Re: Incentive calculation

Kushal_Chawda — Thu, 15 Oct 2020 12:16:31 GMT

@selcukcadir My question is how COS2 for IC1 is getting set as '2'. what is exact logic of calculating set?

Re: Incentive calculation

selcukcadir — Thu, 15 Oct 2020 13:04:37 GMT

@Kushal_Chawda I hope I could explain, sorry