topic Combo Chart with no Dimensions only expressions in QlikView

Combo Chart with no Dimensions only expressions

Thu, 27 Aug 2015 14:11:38 GMT

Good Morning Qlik Community -

I'll try to explain this as best I can -

How do you effectively manage a combo chart when the data sourced is in multiple columns as opposed to rows. For example I have one row of data for supplier ABC and their period 1 parts data is in column B, their period 1 defects are in column C, and so on. How can I use a combo chart to show on bar for period one with the parts and use the line part of the combo chart to show the defects.

Image below is an example of what I'm trying to achieve and sample data is attached.

Thanks for your help with this.

Re: Combo Chart with no Dimensions only expressions

Anonymous — Thu, 27 Aug 2015 18:01:45 GMT

Hi,

What is the dimension (under the bars) in the example ? Is it a period?

Thanks

Re: Combo Chart with no Dimensions only expressions

Thu, 27 Aug 2015 18:45:51 GMT

Yes, I'm looking to have a Period 1, 2, 3, etc. as the dimension.

Re: Combo Chart with no Dimensions only expressions

Anonymous — Thu, 27 Aug 2015 20:11:24 GMT

Hi,

I made an example, see if it solve your problem

Re: Combo Chart with no Dimensions only expressions

Anonymous — Thu, 27 Aug 2015 20:12:42 GMT

attached

Re: Combo Chart with no Dimensions only expressions

Thu, 27 Aug 2015 20:24:10 GMT

Thanks Mauri - that's what I'm looking for. Can you offer some explanation of some items please as I'm still a newbie to Qlik.....

1. Can you explain what CrossTable(Period, Data) does?

2. How do you populate Period....is it subfield(Period,' ',1) as Periodo if so how does it know there are only 3 periods?

3. Resident Teste; and Drop Table Teste can you offer some explanation on what these do/are for as well?

Thanks in advance for your solution -

Re: Combo Chart with no Dimensions only expressions

Anonymous — Thu, 27 Aug 2015 20:37:37 GMT

1. Here is a explanation about CrossTable

The Crosstable Load

2.Subfield is a string function, so it's getting the characteres of field Period before space. You can see an better explanation and example serching for 'subfield' in qlikview's help

3. Resident - works as reload from a table that has already been loaded

Drop Table - delete table Teste

If the answer is correct, please mark the thread is correct to finish the thread