How do I create Temporary Table from Existing

tim_at_ford — Sat, 16 Nov 2024 20:36:48 GMT

Hey everyone!!

I have two tables in my script one for sales and one for orders.

What I need to do is in the reload process create a temporary table that'll be read into a chart object showing my top sales and orders for a given dealer.

I want to group on the dealer and count all the sales in the sales file per dealer and then do the same with the orders. The table should look like this:

Dealer - sales - orders

then I'll chart the sales and orders with dealer name in the legend below for the top ten only.

How do I do that in the load process without generating another QVX from Alteryx?

Example code is welcomed!!

Re: How do I create Temporary Table from Existing

Brett_Bleess — Mon, 22 Jul 2019 18:37:34 GMT

Check the following, believe it should get you on the correct track:

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/load-data-from-previously-loaded-table.htm

Regards,
Brett

topic Re: How do I create Temporary Table from Existing in QlikView

How do I create Temporary Table from Existing

Re: How do I create Temporary Table from Existing