Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Input box not able to display my feild value

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.

1 Solution

Accepted Solutions
sushil353
Master II
Master II

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

View solution in original post

5 Replies
sushil353
Master II
Master II

in the number tab.

past this

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

HTH

Sushil

paulyeo11
Master
Master
Author

Hi Sushi

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

Paul

sushil353
Master II
Master II

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
Master
Master
Author

Hi Sushil

Thank you it work fine again.

Paul

paulyeo11
Master
Master
Author

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