Null Values Solution

kamalqlik — Thu, 24 Jul 2014 05:50:55 GMT

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

Re: Null Values Solution

aveeeeeee7en — Thu, 24 Jul 2014 06:12:17 GMT

Try Something Like this in your Script:

Load

......

FROM ........qvd

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

Regards

Aviral Nag

topic Null Values Solution in QlikView

Null Values Solution

Re: Null Values Solution