topic Re: Year - Combo Graph Problem in QlikView

Year - Combo Graph Problem

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

Hello,

I created one Combo graph. I want to ask you one question, I do have 2014 data from one table and 2015 data from another table. But, now i want to merge those two tables. Here, I am expecting the graph (Combo Chart) of 2014 and 2015 Year wise data.

While i taken two dimension's as Year & Year1 with Expression's are

1) Avg({$<name -= {'Key Message Delivery','Sales Objective Category'}>} Score) - Display options is Bar

2) Avg(Score) - Display options (Symbol - Circle & Line - Normal)

Note: If we can display 2014 & 2015 Data in graph. Now, in my graph it showing 2014 Data only. If possible, Please help me to show those two years. If not, Let me know, Please?

For Ref. PFA of my Application

- Anil

Re: Year - Combo Graph Problem

sunny_talwar — Sat, 02 Jul 2016 13:59:32 GMT

So you want to see two bars and two symbol for 2014 and 2015?

Re: Year - Combo Graph Problem

Anil_Babu_Samineni — Sat, 02 Jul 2016 14:01:19 GMT

I want to see 2014 & 2015 Data in Single Graph with those two expressions.

Re: Year - Combo Graph Problem

sunny_talwar — Sat, 02 Jul 2016 14:16:32 GMT

Where is year 2015 in your application?

Re: Year - Combo Graph Problem

Anil_Babu_Samineni — Sat, 02 Jul 2016 14:19:45 GMT

Sunny,

I have two tables. One table has 2014 & Another table has 2015 Data (Dim - Year & Year1) . So, Now i want to show those two year data with two expressions.

Is that is possible, Because, 2015 Data has another table.

Re: Year - Combo Graph Problem

sunny_talwar — Sat, 02 Jul 2016 14:23:20 GMT

Why don't you concatenate these two tables into one table? If you can share the csv files, I might be able to show you what I am trying to do here

Re: Year - Combo Graph Problem

Anil_Babu_Samineni — Sat, 02 Jul 2016 14:26:32 GMT

Sure,

Updated : I Apologize to forget to add. Thanks.

PFA.

Re: Year - Combo Graph Problem

sunny_talwar — Sat, 02 Jul 2016 14:39:13 GMT

Excel file attached has a weird template for date. Can you check this

If I force 2015 manually using this script:

2014:

LOAD RowNo() as Rowno,

rep,

franchise,

product,

Date,

Year(Date) as Year,

Score,

groupObservation,

name,

Username

FROM

(txt, utf8, embedded labels, delimiter is ',', msq);

Concatenate(2014)

LOAD RowNo() as Rowno,

rep,

franchise,

product,

Date,

2015 as Year,

Score,

groupObservation,

name,

Username,

'2015' as Flag

FROM

[2015Data.csv]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

I get this:

Note: I removed Year1 dimension and now you Year dimension include 2014 and 2015 and you get the chart that you might be looking for

Re: Year - Combo Graph Problem

Anil_Babu_Samineni — Sat, 02 Jul 2016 14:45:54 GMT

Sunny,

Perfect, If we add like FLAG and Concatenate. in future, we are getting any trouble, Right?

Re: Year - Combo Graph Problem

sunny_talwar — Sat, 02 Jul 2016 14:48:44 GMT

Flag's are not bad... but 2015 as Year is risky. I would want to get this year from 2015 from the date. But date isn't right and needs to be fixed

Re: Year - Combo Graph Problem

Anil_Babu_Samineni — Sat, 02 Jul 2016 14:53:03 GMT

Thanks.

1) Here, You know what data you want so that we are written 2015

2) In future, If user want to add more data then how do we justify which is Year?

3) Meantime, Why this is not working

Concatenate(2014)

LOAD RowNo() as Rowno,

rep,

franchise,

product,

Date,

Year(Date) as Year,

Score,

groupObservation,

name,

Username,

'Year(Date)' as Flag

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

Re: Year - Combo Graph Problem

sunny_talwar — Sat, 02 Jul 2016 14:55:51 GMT

Year(Date) is not working because your Date is not right. I have been trying to explain that in my last two posts. You need to make sure that dates are right. Once Date is fixed.... things will flow, does it make sense?

Re: Year - Combo Graph Problem

Anil_Babu_Samineni — Sat, 02 Jul 2016 14:57:17 GMT

Yes, It is?

Now clear.

Thanks Sunny

Re: Year - Combo Graph Problem

sunny_talwar — Sat, 02 Jul 2016 14:58:18 GMT

Super

I am glad the issue is clear now.

Best,

Sunny