topic Re: Grouping table columns by Business names in QlikView

Grouping table columns by Business names

Sat, 27 Jun 2015 19:45:37 GMT

Hi Gurus,

Grouping column by subject area from single fact table.

My fact (FACT1) table has six columns col1,col2,col3,col4,col5,col6. joined with all the dimensions.

FACT1:

col1,

col2,

col3,

col4,

col5,

col6.

Now i want to group columns of the FACT1 into Actuals and Bugets. When user opens the document, want to see table names and columns as follows.

Actuals:

col1,

col2,

col3

Budgets:

col4,

col5,

col6.

Please suggest me approach to provide solution to user.

Thanks,

Sherry

Re: Grouping table columns by Business names

sunny_talwar — Sat, 27 Jun 2015 19:56:46 GMT

Not sure what you mean group? Are you trying to create a cycle or dirll-down group for a table? Can you share an example to understand your requirement?

Best,

Sunny

Re: Grouping table columns by Business names

sinanozdemir — Sat, 27 Jun 2015 21:30:22 GMT

Maybe try something like this. I am just guessing since we don't have an excerpt of your script or data:

Data model will have two tables:

Hope this helps.