topic Re: Chart Layout help Required in QlikView

Chart Layout help Required

spikenaylor1 — Wed, 25 Nov 2020 16:16:04 GMT

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:

Re: Chart Layout help Required

vishsaggi — Tue, 12 Jul 2016 13:53:39 GMT

Hello Michael,

Did you try using line chart from Sheet objects in Qlikview. ?

Can you upload this raw data excel sheet if possible, so that we can work on it to get the most possible look of what you have sent.

Thanks,

Re: Chart Layout help Required

spikenaylor1 — Tue, 12 Jul 2016 17:58:56 GMT

Hi there.

Yes I did try the Line chart both setting up manually and through the chart wizard.

I have attached an excel spreadsheet containing the raw data, a PivotTable and PivotChart created from the Raw Data. This is the type of Chart I am trying to recreate.

I have attached a Qlik sheet containing the Raw Data, a chart created from the Raw Data and a PivotTable created from the Raw Data. I cannot see how to create a Chart based on the PivotTable or how to create a Chart from the Raw Data but looking like my required chart.

Usually in my case, I have missed seeing something in my hastiness to acheive, but would appreciate any help and advice.

Re: Chart Layout help Required

settu_periasamy — Tue, 12 Jul 2016 19:27:01 GMT

May be try to combine the field BatchStrain&' '&BatchNumber in the calculated dimension.

see the screen shot.

Re: Chart Layout help Required

boorgura — Tue, 12 Jul 2016 19:37:56 GMT

This is the closest I could get to a pivot-chart!

Re: Chart Layout help Required

Anonymous — Tue, 12 Jul 2016 19:46:44 GMT

The Grouping in this manner is not possible in Qlikview for a line chart.

Re: Chart Layout help Required

veidlburkhard — Tue, 12 Jul 2016 19:49:33 GMT

Hi, Michael,

as far as I know in QlikView this is possible with the bar chart only. See the picture below:

The workaround is to add an invisible second expression ( I used 0). That's all.

Hope this helps

Burkhard

Re: Chart Layout help Required

spikenaylor1 — Tue, 12 Jul 2016 20:01:31 GMT

I only Have the personal desktop edition at the moment so I cannot open your file.

Re: Chart Layout help Required

spikenaylor1 — Tue, 12 Jul 2016 20:05:01 GMT

It looks nice as a pivot chart in excel and easy for managers to understand. I will have to go with the suggestion from settu_periasamy

Just looks a bit messy

Kind of thought this software would do at least what excel could do and much more.

Re: Chart Layout help Required

vishsaggi — Tue, 12 Jul 2016 20:23:53 GMT

Hello Michael,

The best work around would be the one mentioned by Settu above.

However, if you use BatchStrain in your dimensions with your BatchNumber if would differentiate the Strain by individual colors. Like below:

Re: Chart Layout help Required

boorgura — Wed, 13 Jul 2016 12:35:54 GMT

Can you try now?

Re: Chart Layout help Required

spikenaylor1 — Wed, 13 Jul 2016 12:43:23 GMT

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

Re: Chart Layout help Required

spikenaylor1 — Wed, 13 Jul 2016 12:45:51 GMT

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.

Re: Chart Layout help Required

vishsaggi — Wed, 13 Jul 2016 13:42:26 GMT

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,

Re: Chart Layout help Required

Anil_Babu_Samineni — Wed, 13 Jul 2016 14:34:38 GMT

Like this

Re: Chart Layout help Required

boorgura — Wed, 13 Jul 2016 14:38:32 GMT

Not an ideal way -

Re: Chart Layout help Required

Wed, 13 Jul 2016 14:41:36 GMT

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.