Count Calculation error

bushpalaamarnat — Thu, 19 Apr 2018 09:45:41 GMT

Hi,

in back end, i have a naming done, as material & customer & supplier as %key,

For the same combination in the excel data it say 50, and when extracted from the qlik also it say's 50.

How ever in the table when given count (%Key) i get total as 70, which is more then 50 the actual count.

Total field is the one that does the count.

Re: Count Calculation error

MK_QSL — Thu, 19 Apr 2018 09:46:51 GMT

May be use Distinct in Counting them.

Provide some more info so that we can help you.

Re: Count Calculation error

bushpalaamarnat — Thu, 19 Apr 2018 09:50:08 GMT

Hello Sir,

This is my script, for now let me know this helps.

WeeklyCorridor:

Left join

LOAD

Week,

[Supplier Loc] & [Customer Loc] & Material as %key,

[Customer Loc] & Material as %key2,

Material,

[Material Description],

[Material Type],

Category,

[Inventory Volume],

[Demand Volume (Eaches)],

DFC,

Brand,

Variant,

Lifecycle,

[Customer Loc],

[Customer Location Description],

[Customer Zone],

[Supplier Loc],

[Supplier Gov BU],

[Corridor Status],

[Min DFC],

[Max DFC],

if([Safety Days Supply]='-',0,[Safety Days Supply]) as [Safety Days Supply],

//Creation of rules

IF(((num([Min DFC])+ num([Max DFC]))<> 0) and num([Min DFC]) >= num([Max DFC]),'Reason- Min >= Max') as Rule1,

IF(num([Safety Days Supply]) >= num([Max DFC] ), 'Reason-SSD>Max') as Rule2,

IF(((num([Min DFC])+ num([Max DFC]))=0 AND num([Safety Days Supply]) <> 0),'Reason-SSD has value when Min & Max is zero') as Rule3,

If((num([Min DFC]) + num([Max DFC]))=0,'Reason-Min Max not set') as Rule4,

IF( Lifecycle='Material Run Down' and (num([Min DFC])+ num([Max DFC]))<>0, 'Reason-RunDown SKU Min & Max > Zero') as Rule5,

IF(num([Safety Days Supply]) <= num([Min DFC]), 'Reason-SSD <= Min') as Rule6,

IF([Safety Days Supply]='-' and num([Max DFC])>0, 'Reason-SSD not set') as Rule7,

IF([Safety Days Supply]='-' and (num([Min DFC])+ num([Max DFC]))=0, 'Min & Max = Zero') as Rule8,

if([Min DFC]='-' and [Max DFC]='-','Reason-Min Max not set') as Rule9,

Re: Count Calculation error

bushpalaamarnat — Thu, 19 Apr 2018 09:53:42 GMT

Hi Sir,

How do i use distinct in this formula

sum(if(Inventory_Position='Overstock',1,0))

topic Re: Count Calculation error in QlikView

Count Calculation error

Re: Count Calculation error

Re: Count Calculation error

Re: Count Calculation error