Line Chart expression help.

[sona_sa]

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.

[MK_QSL]

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

[sona_sa]

Can you guide me by using same attached QVW application.

Thanks for reply.

[santhoo_san]

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))