Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a problem and not get ahead.
I have a excel table and make a line chart with 3 graphes A, B and C.
Showing all 3 graphes displayed simultaneously in the line chart.
How can I switch to a filter between A, B and C.
Thanks in advance!
Kai
Hi Kai,
The issue is the structure of your data this data is in a 'cross table' format and you need to 'uncross' it to make it easier to use. There is a function you can add in the data load editor to do this called "Cross Table". I assume your data was made up of Products and Prices but you can choose any labels that makes sense. Your script would look something like this:
CrossTable(Product, Price, 1)
LOAD
"Week",
A,
"B",
C
FROM [lib://Desktop/Example Data.xlsx]
(ooxml, embedded labels, table is Sheet1);
I've also included an example QVF for your reference.
-Josh
Qlik
I use Qlik Sense Desktop.
Hi Kai,
The issue is the structure of your data this data is in a 'cross table' format and you need to 'uncross' it to make it easier to use. There is a function you can add in the data load editor to do this called "Cross Table". I assume your data was made up of Products and Prices but you can choose any labels that makes sense. Your script would look something like this:
CrossTable(Product, Price, 1)
LOAD
"Week",
A,
"B",
C
FROM [lib://Desktop/Example Data.xlsx]
(ooxml, embedded labels, table is Sheet1);
I've also included an example QVF for your reference.
-Josh
Qlik
Thanks Josh!