topic Re: Avoiding '-' Values in QlikView

Avoiding '-' Values

NavinReddy — Tue, 28 Jul 2015 20:12:05 GMT

Hello Experts,

i have table like this im trying to avoid blanks with different expressions which im not able to achive can some one help me

how can i avoid blanks in scrip side

Where Match([Controls LOB] ,'Mortgage Banking','Transaction ','Card ','Auto','Student' Commerce Solutions',' IT');
Where Not Match( [Controls LOB] ,'-' or [Controls Load_Date],'-');
Where len(Trim([Controls LOB])>0);

i used in my script these expressions but still im getting blanks in chart

can some one help me

Thanks In Advance

Niranjan

Re: Avoiding '-' Values

sunny_talwar — Tue, 28 Jul 2015 20:14:35 GMT

Try this one again with correct placement of parenthesis:

TableName:

LOAD yourFieldNames,

[Controls LOB]

FROM SourceFile

Where Len(Trim([Controls LOB])) > 0;

Re: Avoiding '-' Values

sunny_talwar — Tue, 28 Jul 2015 20:17:29 GMT

Also I hope you are not creating a table box object with fields from different tables in your database. Cause if you are then you might still see blank [Controls LOB] because they don't have a value for them from another table you have in your table box object.

Re: Avoiding '-' Values

NavinReddy — Tue, 28 Jul 2015 20:23:25 GMT

Yes still im getting blanks because another mapping table don't have data is that reason

Re: Avoiding '-' Values

sunny_talwar — Tue, 28 Jul 2015 20:26:50 GMT

I don't think mapping table in itself could be an issue. But where ever you are mapping it to (using applymap) may have empty rows causing the issue. Can't really say anything without seeing it.

Re: Avoiding '-' Values

NavinReddy — Tue, 28 Jul 2015 20:30:34 GMT

thanks i think your above answer is might correct