topic Re: Line Chart expression help. in QlikView

Line Chart expression help.

sona_sa — Thu, 18 Jun 2015 03:21:04 GMT

Hi,

I have some data on behalf of region wise No. of License allocation (Expiry Date and Deployed Date). With User Logins Details.

Suppose I select Division = 'Puma' and Name = 'Africa', You can see there is two row are available. If we see there is 2 License date.

1. 19/10/2014 - 401

2. 14/06/2015 - 511

Now What I want, For Afica No. of License - a line for No. of License which show me Before 14/06/2015 = No. of license should display 401 and after or from same date 14/06/2015 (No. of License should be 511).

If It works as a reference line. It would be great.

For more ref. please find the attached qvw.

Thanks.

Re: Line Chart expression help.

MK_QSL — Thu, 18 Jun 2015 06:25:33 GMT

You can use text in chart...from presentation tab

Re: Line Chart expression help.

sona_sa — Thu, 18 Jun 2015 07:02:19 GMT

Can you guide me by using same attached QVW application.

Thanks for reply.

Re: Line Chart expression help.

santhoo_san — Thu, 18 Jun 2015 09:41:24 GMT

Hi Arun,

See if this helps. I have just added one more expression to your graph.

if(max(CDate)<=max(date(LicenseDeployDate)),

min(NoOfLicense),max(NoOfLicense))