topic Creating Separate Tables from single table in QlikView

Creating Separate Tables from single table

Fri, 18 May 2012 17:23:15 GMT

Hi All,

I am looking to take a single table like this:

Field ID	Value
1	hjjhgj
4	dfsdfsd
1	sfsd
2	sdfsdf
2	g
3	fdgfdg
4	dfgfdg

And break it into multiple individual table, such as this:

Table 1

Field ID	Value
1	hjjhgj
1	sfsd

Is this done in the script?

Thanks,

Alan

Creating Separate Tables from single table

Jason_Michaelides — Fri, 18 May 2012 17:29:22 GMT

I'm not sure if you can use them with Straight Table charts, but you could maybe look at using Tellis charts with FieldId as both first and second dimension.

Hope this helps,

Jason

Creating Separate Tables from single table

swuehl — Fri, 18 May 2012 17:29:44 GMT

Do you just want separate charts per Field ID in the front end?

If not, I don't understand why you want to split your table into several tables in the data model, could you explain the reason for that?

Creating Separate Tables from single table

Sat, 26 May 2012 08:48:17 GMT

Hi swuehl,

Thanks for your question.

That is exactly what I want - I needto be able to create separate tables on the front end.

I will also need to create a tablethat contacts many of the values side by side, which is why I want them inthe data model as separate fields.

Thanks again.

Creating Separate Tables from single table

swuehl — Sat, 26 May 2012 13:42:16 GMT

If your field IDs are limited and you know all of them upfront, you could create straight tables, one for each ID and use Field ID and Value as dimension and

=sum({<[Field ID]={1}>} 1)

as expression (and hide this expression column in presentation tab). Replace the Field ID in the set modifier element list in each chart (1-->2-->3--->4...)

I assumed you just want to show the values in your table, no aggregation of values required (that's not much different, just limit your field value by a calculated dimension or a set expression).

Unfortunately, there is no trellis feature available for table charts. If you are using bar charts etc. you could try a trellis as suggested by Jason (available from dimension tab).

A trellis a kind of dynamically creating your charts, even if you don't know the exact number of dimension values.

You can also try using a Macro to create a chart for every dimension value, but I think this will be quite a lot of work to create a good layout of the charts ( this might also be the case for the trellis).

I think QV is just not really good at presenting data in the way you are looking for, because that's more a kind of traditional reporting style (like a section in Desktop Intelligence or Crystal Reports).

Sorry if all that's not very helpful for you.

Stefan