topic Triming repeated data in QlikView

Triming repeated data

Fri, 21 May 2010 06:08:05 GMT

Hi,

I am importing some tables from a DAtabase.

In one of the tables there is attribute 'xyz'

Now, This Attribute has values as multiple numbers followed by comma(,) and some of them may have the data

Something like this:

235,235,235

211,222,275,

256,289

Now for the first row(235,235,235) IN a Pivot table I would like to view it only as '235' without affecting the value of other rows.

i.e row (211,222,275) should appear as it is.

Is it possible.?

Thanks & Regards,

Rohit

Triming repeated data

Fri, 21 May 2010 06:53:45 GMT

Hi,

Here you go.

Check the attached application.

Your code should be as follow.



 Test:
Load Product,
subfield(Sales,',') as Sales_New,
Sales;
LOAD * INLINE [
 Product, Sales
 a, "235,235,235"
 b, "235,236,237"
 c, "222,222,222"
 d, "222,223,224"
];
Test1:
Load Product,
if(Peek(Product) = Product and peek(Sales_New) = Sales_New, Sales_New,Sales) as Sales_New1,
Len(if(Peek(Product) = Product and peek(Sales_New) = Sales_New, Sales_New,Sales)) as Length,
Sales,
Sales_New
Resident Test;
Drop Table Test;
Right Join(Test1)
Load Product,
Min(Length) as Length
Resident Test1 group by Product;

-Peterson

Triming repeated data

spsrk_84 — Fri, 21 May 2010 06:54:29 GMT

Hi,

one solution use a if condition but it works for only one selected value as of now

assume ur field name is Value

in that write the if condition like

if( Value= ' 235 , 235 , 235 ' , left(Value,3) , Value) as Value if u use this logic in script

else it will be like thiis if( Value= ' 235 , 235 , 235 ' , left(Value,3) , Value)

check this i hope it is solved..

Regards,

Ajay