topic Re: Why string filed add trim does not work ? in QlikView

Why string filed add trim does not work ?

Tue, 27 Aug 2013 13:53:45 GMT

Hi All

I have a table , when i select CX8095 i am able to display the description.

But when i select the model CX9000 , it unable to display description ?

Enclosed my QV Doc. which explan clearly my situation.

http://community.qlik.com/thread/90240

Just now Tres , have help me add trim on the field name , it work fine for number field which is not number format .

I am not sure for string, how to make it 100% string ?

Paul

Re: Why string filed add trim does not work ?

rajeshvaswani77 — Tue, 27 Aug 2013 14:05:30 GMT

Hi,

Could you please check? Have corrected the QVW.

thanks,

Rajesh Vaswani

Re: Why string filed add trim does not work ?

Tue, 27 Aug 2013 14:23:24 GMT

Hi Raj

Thank you very much. any idea why description field can not put at expression ? why only CX9000 have problem ?

Paul

Re: Why string filed add trim does not work ?

rajeshvaswani77 — Wed, 28 Aug 2013 13:05:08 GMT

Hi Paul,

All information is in the singlee row, so cannot be put as an expression. Unless you were calculationg/deriving something. This had multiple descriptions and we were giving the expression as a column name.

thanks,

Rajesh Vaswani