Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

TableBox Queries

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..

11 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    Let me tell you something about Tablebox in Qlikview.

    TableBox is a place where you show the row data which you have loaded in Qlikview.

    So you will not be able to do any manipulation at Tablebox.

    You asked that

    1- Can I add anonymous column to tablebox

    Can you tell us what kind of column you would like to add? is that column coming from table which you have loaded?

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

    Yes you can rename the filed's when you display the fields in tablebox.

     For this you need to click on the field and at the bottom you will find the space to give user defind labels.

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

   

     As i said earlier its not possible to apply manipulation on Tablebox. For this you need to use Charts(i.e pivot table or Straight Table)

    Hope you got answers.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

How can I calculate the total records in my tablebox?

rahulgupta
Partner - Creator III
Partner - Creator III

Hey Hi,

In that case you have to use a Straight table or a pivot chart.

Use all the Fields in the Dimension Tab and use '1' in the Expression Tab, After that use Show Partial Sum on the 1st Dimension.

Hope this helps

Regards    

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    If you just want to know the total records of a table, then you will come to know this from

  

    Settings -> Document Properties -> Tables

    Here you will get all the information like the no. of total rows. No.of distinct rows and many more.

   

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jagannalla
Partner - Specialist III
Partner - Specialist III

Kaushik,

In this Tables tab if i check Loosly coupled checkbox for one table what will happen in backend.

Not applicable
Author

Hi,

Actually I am loading data to qlikview by loading data from a txt file through edit script option.

So, how to create a straight box.

And I need to show four fields on my sheet ie: total records, matched records, unmatched records and excluded records.

I am doing data comparison between two sources and I have done that by using tableboxes. Now the business want to see it in more brief way like I have said.

Please assist me if it is possible in Qlikview.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   The full description is given in help file. Please go through the Help content.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

hi,

I got to know how to create a straight box..

My task is I am fetching data from two data sources x, y.

x has x.x1, x.x2. x.x3,x.x4,x.x5.  Y has y.x1, y.x3, y.x5.

Need to compare these are all columns. And have to show the matched, unmatched, total records and excluded records.

Can it be possible through Qlikview.

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

    You can do this way.

     Create a straight table with dimension as

     x.x1, y.x1 x.x3, y.x3,x.x5, y.x5 

     Add expression as

     If(X.X1 = Y.Y1 and X.X3 = Y.Y3 and X.X5 = Y.Y5, 1,0) - Give label to this expression as Matched.

     

     If(X.X1 = Y.Y1 and X.X3 = Y.Y3 and X.X5 = Y.Y5, 0,1) - Give label to this expression as UnMatched.

     Enable the total mode.

     This way you will get the total matched and total unmatched.

Regards,

Kaushik Solanki  

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!