Null Values Solution

[kamalqlik]

Hi Guys,

I want the solution for this problem.

I have a table having structure like this

LOAD * Inline

[

Code,SKU,w(-8),W(-7),W(-6),W(-5),ActualSalesW0

WESR150,E1200Black,100,70,30,120,75

WESR150,E1200White,150,0,20,160,90

WESR150,E1207Black,,,50,50,0

];

I have also attached screenshot for the table structure and calculation.

Calculation for input rate as per excel is :Average(If( [Actual Sales]=0,Null(), Count If(week-5 toWeek-8,’>0’)/4)).

How can I do that in qlikview.

* Where the value is null for Actual Sales W0 we have not to calculate the count.

Regards

Kamal

[aveeeeeee7en]

Try Something Like this in your Script:

Load

......

......

FROM ........qvd

WHERE Len(Trim(Actual Sales Amount Field Name))>0;

Regards

Aviral Nag