Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt
Specialist
Specialist

Many tables in one table

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!

8 Replies
pgalvezt
Specialist
Specialist
Author

Any Help?

Thanks!

pgalvezt
Specialist
Specialist
Author

Any can help me with this?

Thanks!

pgalvezt
Specialist
Specialist
Author

Anyone?

Thanks!

marcus_sommer

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

pgalvezt
Specialist
Specialist
Author

Hi Marcus,

Thank you for your reply.

Could you please put an example with my test app?

Thanks!

marcus_sommer

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

- Marcus

pgalvezt
Specialist
Specialist
Author

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!

marcus_sommer

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

- Marcus