topic Re: Many tables in one table in QlikView

Many tables in one table

pgalvezt — Wed, 28 Jan 2015 20:08:29 GMT

Hello,

This is in Excel:

I need to create this in one table. OK is ready. BAD Separate Tables.

If you need more information just let me know.

I attached a test QV with I have it.

Thanks!

Re: Many tables in one table

pgalvezt — Thu, 29 Jan 2015 14:03:25 GMT

Any Help?

Thanks!

Re: Many tables in one table

pgalvezt — Thu, 29 Jan 2015 19:09:06 GMT

Any can help me with this?

Thanks!

Re: Many tables in one table

pgalvezt — Fri, 30 Jan 2015 14:19:14 GMT

Anyone?

Thanks!

Re: Many tables in one table

marcus_sommer — Sat, 31 Jan 2015 10:07:02 GMT

I think you will need for this a dimension-less pivot-table and use for each item a single expression. For the variable you will probably need an independent single inputfield. The doing is quite similar to excel ...

- Marcus

Re: Many tables in one table

pgalvezt — Mon, 02 Feb 2015 11:59:07 GMT

Hi Marcus,

Thank you for your reply.

Could you please put an example with my test app?

Thanks!

Re: Many tables in one table

marcus_sommer — Mon, 02 Feb 2015 12:17:43 GMT

I'm not sure if you really needed such datamodel ... but see the attachment to what I meant.

- Marcus

Re: Many tables in one table

pgalvezt — Mon, 02 Feb 2015 12:42:36 GMT

ok, I already did that before, but check out that "Otros Ingresos de la explotación" still appears.

Only I need "Ventas" "Costos" and "Margen".

After that I would like put only Total GAV. and so on. just like excel file order.

Thanks!

Re: Many tables in one table

marcus_sommer — Mon, 02 Feb 2015 12:54:45 GMT

You could put the expressions which you want in this table and the order could you set with expression-options up and down.

- Marcus