topic Re: Extracting columns to another table in QlikView

Extracting columns to another table

Thu, 24 Oct 2013 12:25:29 GMT

Hello,

I have a big table with ~100 columns. For a better view and navigation I want to break it down to sets of columns. So I used a container with x tables and each of them shows different columns (2-3 are always the same for a reference).

My question is how can I extract some non-defined columns to another table inside QV and then add more columns from other tables like concatenate them? For instance take 5 from one table, 4 from another and 6 from a third and form a 15-column table, for instance to extract of view specific data together. But the thing I want them to be user-defined and not standardized.

Thanks

Re: Extracting columns to another table

tresB — Thu, 24 Oct 2013 12:37:31 GMT

May like described in 'What's New QlikView11' app. See attached sample, 'Report' tab, there users can select the dimensions they want in the table.

Re: Extracting columns to another table

Thu, 24 Oct 2013 12:52:43 GMT

Unfortunately I can't view files because I have a personal edition. Can you tell me how you do the dimensions pick?

And is there a way to break the link between two tables? I could do what I want by putting the whole table and picking dimensions but I don't want to do it with qualify for so many columns, otherwise I will get joins etc.

Re: Extracting columns to another table

tresB — Thu, 24 Oct 2013 13:03:44 GMT

In QV11 there is conditional enablement of dimensions. Using that, you can dinamically select dimensions in the chart.

Re: Extracting columns to another table

Thu, 24 Oct 2013 14:22:13 GMT

Thanks, I will try that but I couldn't find the tags tab!

Re: How to show hidden dimensions like on what's new in QV 11?

Is there a way to group columns of a table? And have a list to pick each group? One way is to break it down to more tables and use the container but it doesn't seem right and efficient.