Change the data for timeline chart

sudhakarsamak06 — Sat, 16 Nov 2024 20:31:42 GMT

I have the following data

1971/01 Quantity	1971-01 Amount	1971-07 Quantity	1971-07 Amount	1972-01 Quantity	1972-01 Amount	1972-07 Quantity	1972-07 Amount
2	10	5	15	3	69	4	52
4	10	2	30	7	96	8	66
5	45	7	32	2	59	3	47

Now i want to convert this data into a format which i can use for a timeline chart. With the year in x-axis, i want to display the total amount and and quantity as the lines in a line chart. Basically i want to convert the above data into something that looks like this:

Year	Quantity	Amount
1971	25	142
1972	27	389

Could someone please help me do this in Qlikview.

PS: I have a lot more fields than i have mentioned here. I am using data from 1971 - 2019.

Re: Change the data for timeline chart

Brett_Bleess — Tue, 30 Jul 2019 18:09:50 GMT

I believe what you want to look into is the Crosstable function:

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm

Also found a Design Blog post along the same lines that may be helpful as well:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083

Regards,
Brett

topic Re: Change the data for timeline chart in QlikView

Change the data for timeline chart

Re: Change the data for timeline chart