Discussion Board for collaboration related to QlikView App Development.
I have to add two different rows of the same column in a pivot table & straight table and put the data in the same row. for eg. below there are two rows china>>india and india>>china and 3rd row represent the sum of the above two row(in red).
try something like this
tab2: load rangeminstring(subfield(corridor,'>>',1),subfield(corridor,'>>',2)) as from, rangemaxstring(subfield(corridor,'>>',1),subfield(corridor,'>>',2)) as to, value resident Tab;
and sum your data by dimensions from and to
with maybe ltrim and rtrim to remove white spaces
Can u please give me the expressions which you have written. I can see in the column missing expressions.
the expressions are above
i created a new tab tab2 and my graph was made based on this table
from ans to as dimensions
sum(value) as measure