Discussion Board for collaboration related to QlikView App Development.
Attached please find the sample qvw, sample Excel . What I am trying to accomplish is as per the snapshot policy number 356541 has multiple file numbers assigned to it and also there is a null value assigned to the same policy number. In a case like this where there is even 1 File number exist for a policy number I want to eliminate the rows for the same policy number with null values, but if Null Value is the only entry available for a policy then I want that Null value for example in this case I would like to see the row for policy number 36547.
I am sorry, If i misunderstand over here
Load * From <Data Source> Where File <> Peek('File', -1);
Load * From <Data Source> Where Previous(File) <> File;
Now your question makes confuse, Would you share expected result on wall
You mean to say, You want to exclude all File Null values
Load * From <Data Source> Where Len(File)>0;
I really don't why you need this. For your question answer may be this
Load * From <Data Source> Where If(Previous(POL_POLICYNUMBER) = POL_POLICYNUMBER,Len(File)>0, POL_POLICYNUMBER)
Does that answer your question?
(biff, embedded labels, table is Sheet1$);
Count(File) as FileCount
Resident Data Group by POL_POLICYNUMBER;
Where (FileCount > 0 And Len(Trim(File))>0) Or FileCount =0;
DROP Field FileCount;
DROP Table Data;