Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

d_pranskus
Contributor III

Table with independent columns

Hi

I am wondering, is it possible to create a QV table, whose columns are independent? It would be used for various selectors. Now I am using island tables for each selector, but it would be nice to have one table for all selectors, having each as separate field. It will reduce the overall database model. Model looks not elegant when there are many island tables with just one field in them.

I can join all these selector tables together, but in this case lots of rows are generated by cross join.

What approach do you use for that? Maybe there is simple and elegant approach.

Thank you very much

Darius.

Tags (2)
1 Reply
d_pranskus
Contributor III

Table with independent columns

Hi

Seems to be this is achievable with Loosen Table command. Need to check

Thanks

Community Browser