topic Input box not able to display my feild value in QlikView

Input box not able to display my feild value

paulyeo11 — Tue, 13 Aug 2013 22:45:13 GMT

Hi All

I have a Table 1 list box , which not able to display my field S_Price.

I am able to display the value on pivot table 2.

sushil353 — Tue, 13 Aug 2013 22:47:23 GMT

in the number tab.

past this

USD$ #,##0;($#,##0)

HTH

Sushil

paulyeo11 — Tue, 13 Aug 2013 22:54:30 GMT

Hi Sushi

I try but it still not work. can you pls post me qve file pls.

Paul

sushil353 — Tue, 13 Aug 2013 22:58:42 GMT

Sorry, i didnt read your issue properly..

open variable overview cltr_alt_v or go to settings>variable overview.

there find out the variable s_price.

click on that variable and in the definition box below paste

=sum(S_Price)

there you go !!

HTH

Sushil

paulyeo11 — Tue, 13 Aug 2013 23:12:32 GMT

Hi Sushil

Thank you it work fine again.

Paul

paulyeo11 — Tue, 13 Aug 2013 23:14:19 GMT

Hi Sushi

May i know i notice that

for expression :-

sum([S_Price])

for variable

=sum([S_Price])

My question is when to add = sign ? when not to add = sign ? it there a rule on syntax ?

Paul