How to display data in Table box ?

[#1]

I am new to QlikView, Can any one help me in this.

In my table box i have a division field and i want to display records only for divisionid 1 and 2 and for other values it should display error message. I have written condition DivisionID=1 or DivisionID=2 but when i am trying to select both 1 and 2 then it is showing error message . How to display 1 and 2 records together when i select both.

Thanks in advance.

[petter · Accepted solution]

Could you show.us what you got so far with screenshots or upload your qvw?

[b_garside]

A TableBox wont let you do much. Perhaps use a regular Straight Table will allow this to be much easier?

But if you have to use a TableBox then you may have to embed the logic at the script level since this object type doesn't allow expressions. as Peter mentioned please post examples.

[Colin-Albert]

You cannot use expressions in a table box.

Try using a Straight Table instead as this is more versatile as you can add Dimensions and Expressions.

A table box is best considered as a set of linked list boxes - a table box lists the unique data vales across the fields in the table box, not does not show all data rows.

So if a set of data is repeated within your data, it will only show once in a table box not 4 times, whereas a chart (straight table) will sum the 4 values correctly.

[petter]

Is it something like this you had in mind? It is best solved with a Straight Table - I don't think you could do it properly in a Table Box at all - have a look at the attached QVW to see how it has been done:

[#6]

Hi Petter,

Thanks for your reply. I have attached Screen shots . In Table box Properties i have written DivisionID=1 or DivisionID=2 in Caluculation Condition. In the 3rd Image when i select 1 and 2 together it is showing an error but i want to get the data of both 1 and 2. Is there any way to get the data of both 1 and 2 (Or) Correct me if i am wrong.

[petter]

You could have either of these two expression as Conditional Show expressions:

• Max(DivisionID)<=2

• Max(DivisionID)=2 OR Max(DivisionID)=1

[#8]

Thanks Petter now Its working.