Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

combition of filed valules to yield new field

Hi,

i am sharing thes sample app

here in this app

1)i need list box with the third value as "TotalITem"

2) pivot chart wth the totalItem showing the sum of old and new items values.

help me out

1 Solution

Accepted Solutions
tresesco
MVP
MVP

values:
LOAD * INLINE [
    Item, Value
    old, 10
    new, 20
   
];

Load
'TotalItem' as Item,
Sum(Value) as Value
Resident values;

PFA

View solution in original post

5 Replies
MK_QSL
MVP
MVP

Add one more expression

SUM(TOTAL Value)

if you want 30 irrespective of selection, use SUM(All Value) as your expression..

tresesco
MVP
MVP

values:
LOAD * INLINE [
    Item, Value
    old, 10
    new, 20
   
];

Load
'TotalItem' as Item,
Sum(Value) as Value
Resident values;

PFA

View solution in original post

Not applicable
Author

Did not get your point. Can you please elaborate.

Not applicable
Author

Yes, it shows the result but we cant use that as a dimension right?

like i want that as a field in list box how to do that?

MK_QSL
MVP
MVP

Table1:

LOAD * INLINE [

    Item, Value

    old, 10

    new, 20

];

Concatenate

Load

'TotalItem' as Item, Sum(Value) as Value Resident Table1;