TableBox Queries

[#1]

Greetings All,

I am using Qlikview10 personal edition.

I would like to ask you set of queries regarding tablebox :

1- Can I add anonymous column to tablebox

2- Can I rename the the field(column) of tablebox.

3. Can I show matched, unmatched, excluded records, total records in qlikview..

Thanks in Advance..

[jagannalla]

Sandeepa,

Can you try this.

Take x.x1,x.x2.x.x3,y.x1,y.x2.y.x3 in - Dimensions and in expresssion

=if(X.F1=Y.F1 and X.F2=Y.F2 and X.F3=Y.F3,'Matched','Unmatched')  //  if all column values are matched then it displays Matched otherwise UnMatched

=if(X.F1=Y.F1 or X.F2=Y.F2 or X.F3=Y.F3,'Matched','Unmatched')  //   if any one column value are matched then displays Matched otherwise UnMatched

Hope this may help u..

[#3]

Hi,

Thanks..!

I have successfully done the matched and unmatched records..

There are set of fields which are not used in the report. I have to show them in excluded reports..

And need to show the total record at row level(table level) not at the field level.