topic Re: How to display data in Table box ? in QlikView

How to display data in Table box ?

Tue, 19 May 2015 18:51:11 GMT

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.

Re: How to display data in Table box ?

petter — Wed, 20 May 2015 17:50:23 GMT

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

Re: How to display data in Table box ?

b_garside — Wed, 20 May 2015 18:00:34 GMT

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.

Re: How to display data in Table box ?

Colin-Albert — Wed, 20 May 2015 18:21:45 GMT

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.

Re: How to display data in Table box ?

petter — Wed, 20 May 2015 18:43:31 GMT

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:

Re: How to display data in Table box ?

Wed, 20 May 2015 19:16:17 GMT

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.

Re: How to display data in Table box ?

petter — Wed, 20 May 2015 19:24:19 GMT

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

Max(DivisionID)<=2

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

Re: How to display data in Table box ?

Wed, 20 May 2015 19:33:32 GMT

Thanks Petter now Its working.