Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am trying to create a line graph such as the one below shown in Excel. How would I use crosstable on my table below in order to achieve something similar.
Thank you in advance!
Accepted Solutions
Hi,
I do not see the link between the first screen copy and the 2 others. I will try an answer considering you want to use a crosstable on the second table. Let's imagine you have a table with Partner dimension and then columns per date with the value for each partner (SOURCE table in my example).
You would like to convert this in a new table with Partner, Date, Value fields (DATA).
You can use :
About Crosstable : https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes...
Regards
Hi,
I do not see the link between the first screen copy and the 2 others. I will try an answer considering you want to use a crosstable on the second table. Let's imagine you have a table with Partner dimension and then columns per date with the value for each partner (SOURCE table in my example).
You would like to convert this in a new table with Partner, Date, Value fields (DATA).
You can use :
About Crosstable : https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes...
Regards
