topic Re: When i select A Table can display amount , But select B it does not work ? in QlikView

When i select A Table can display amount , But select B it does not work ?

Tue, 27 Aug 2013 09:01:27 GMT

Hi All

I have a table , when i select Bus Terminal i am able to display the COST PRICE.

But when i select the Training , it unable to display COST PRICE ?

Enclosed my QV Doc. which explan clearly my situation.

Paul

Re: When i select A Table can display amount , But select B it does not work ?

tresB — Tue, 27 Aug 2013 09:15:23 GMT

Your Price(Euros) , is not a numeric field.

Update: try this expression:

Num(trim([COST PRICE]))*(1-[Discount])

Re: When i select A Table can display amount , But select B it does not work ?

Tue, 27 Aug 2013 10:39:59 GMT

Hi Tres

You very smart.

lucky you give me the trim command , otherwise i will have to manually edit mt excel raw data file which will take up a lot of time which is very unproductive. now i can appreciate the power of trim command.

Paul