topic Re: Line chart issue? in QlikView

Line chart issue?

Tue, 17 May 2016 04:47:45 GMT

HI All,

Need to create a Line chart based on Actual & Plan.

My Requirement is when Actual minus plan Then particular subdivision should be highlighted...

If Possible needed to show the difference of those days based on the subdivision..

Division Subdivision Actual Plan

Gen care Medical 01/11/2015 09/11/2015

Gen care Webinars 01/22/2016 01/24/2016

Gen care Confere 03/14/2016 03/14/2016

Gen care Tution 05/12/2016 05/15/2016

Gen care SMEs 05/18/2016 05/25/2016

Gen care Young 06/11/2016 06/11/2016

Gen care Launch 07/05/2016 07/11/2016

Gen care Classes 08/19/2016 08/24/2016

Kindly help on this..

Regards,

Helen

Re: Line chart issue?

Tue, 17 May 2016 05:00:11 GMT

Hi Helen

You can create a calculated dimension to only show the Subdivision when the Actual is smaller than the plan

In the Dimensions tab, click Add calculated dimension and then use an if statement like - if(Actual < Plan, Subdivision)

Re: Line chart issue?

jonathandienst — Tue, 17 May 2016 05:21:29 GMT

First of all, make sure the dates are being loaded as proper numerical dates. Your actual requirements are a little unclear. Do you a tables showing detail with selected subdivision lines highlighted, or a table summing the time differences by subdivision?

QlikView Date fields‌

How to use - Master-Calendar and Date-Values

If the date fields are numeric date values, then the difference is the number of days. Create a chart with subdivision as the dimension and Sum(Actual - Plan) as the expression.

>>My Requirement is when Actual minus plan Then particular subdivision should be highlighted

When actual minus plan is what?

Re: Line chart issue?

Tue, 17 May 2016 05:35:14 GMT

Hi,

We can show difference in days of Actual - Plan. But here in your case All the dates of Actual is greater than Plan. So, number of days will be comes in negative numbers. Please Elaborate your requirement.

Re: Line chart issue?

Kushal_Chawda — Tue, 17 May 2016 05:36:45 GMT

What is expected output?

Re: Line chart issue?

Tue, 17 May 2016 06:35:28 GMT

Expected Out put :

Need to pull in chart with Actual & Plan Dates, So two line charts will come..

If date matches for any particular division, then It should be high lighted with Some Color or any way..

(It means Particular sub division is On Date because of (Actual - Plan ='0'), remaining dates which are not matching actual & plan dates should be remain Same..

Thanks,

Helen

Re: Line chart issue?

kkkumar82 — Tue, 17 May 2016 06:55:35 GMT

didn't understood ur expected output,

What should be the dimenison for the line chart and what you want to see as values for that subdivision

Can you elobarate with you data

Re: Line chart issue?

kkkumar82 — Tue, 17 May 2016 06:59:29 GMT

Not sure, I understood your requirement correctly but see the attached.

Re: Line chart issue?

HirisH_V7 — Tue, 17 May 2016 06:59:33 GMT

Hi,

Can you please plot your required output on excel or anyway.

-Hirish

Re: Line chart issue?

Tue, 17 May 2016 07:04:33 GMT

HI Kumar,

U r nearer..

I need all the Subdivisions in the Chart, What ever the matching Dates are there for (Young, Confere) Should be identified these are having matching dates.

Re: Line chart issue?

kkkumar82 — Tue, 17 May 2016 07:21:42 GMT

I think in your data only two dates are matching, if I am correct, can you check once.

Re: Line chart issue?

Tue, 17 May 2016 07:26:22 GMT

yes..

Matching Dates subdivision needs to be Highligted with some color..

but remaining dates for the subdivisions also should show..

Re: Line chart issue?

kkkumar82 — Tue, 17 May 2016 07:34:04 GMT

May be this

Re: Line chart issue?

Anil_Babu_Samineni — Tue, 17 May 2016 07:52:53 GMT

Yes,

Kumar - He is same as like you.

How to set the color which is high lighted..

Re: Line chart issue?

kkkumar82 — Tue, 17 May 2016 08:24:53 GMT

Hi Anil,

goto the expressions tab and click the + symbol for the expression , Text color