Discussion Board for collaboration related to QlikView App Development.
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
values:LOAD * INLINE [ Item, Value old, 10 new, 20 ];
Load 'TotalItem' as Item, Sum(Value) as ValueResident values;
View solution in original post
Add one more expression
if you want 30 irrespective of selection, use SUM(All Value) as your expression..
Did not get your point. Can you please elaborate.
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?
LOAD * INLINE [
'TotalItem' as Item, Sum(Value) as Value Resident Table1;