Chart Layout help Required

[spikenaylor1]

How can i Create a similar looking Chart to the one below in Qlikview 12.

I cannot see any help or links to do this. Any help or advice greatly received.

In Excel I can create a pivottable then a chart from that giving me a grouped x axis chart.

the raw data looks like:

[boorgura]

Can you try now?

[spikenaylor1]

Nope, it asks me to recover and use some of my recovery attempts

[spikenaylor1]

Looks good and I can get it to work, but I now need to sort my raw data on loading to sort it into batchstrain.

Can't get mine to sort as you have done.

How have you sorted the data.

[vishsaggi · Accepted solution]

Oh sorry Michael, I have used a key to sort rather than the BatchStrain field.

I have used the below script to load and used the keynumber in the sort expression.

LOAD AutoNumber(BatchStrain) AS KeyNumber,

     Volume,

     BatchStrain,

     BatchNumber

      FROM

[..\Desktop\Qlik-ExcelTest.xlsx]

(ooxml, embedded labels);

Let me know if this helps.

Thanks,

V.

[Anil_Babu_Samineni]

Like this

[boorgura]

Not an ideal way -

[#8]

Did you try adding both the dimension Strain and batch number to your data ? It should be rather straight from there. You may use line area under appearance for further specifications.