Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Reference line only for current year

Hello friends,

I want to make a horizontal reference line in my x axis for the currenr date only. The problem is that by using an expression like =num(month(Today())) and having the month numbers on x-axis i create a reference line for all my years an not only the current....I have also tried =Year(Today()) expression in conditional but does not seem to work.Any ideas???

Thank you in advance

1 Solution

Accepted Solutions
Not applicable
Author

I manage to implement the first part of my question by using the expression =if( SubField(b.TestMonthYear,'-',1) <= SubField(vTODAY,'-',1),if(SubField(b.TestMonthYear,'-',2) < SubField(vTODAY,'-',2),sum(b.QtyInvoiced),sum(b.ForecastQty)) ,sum(b.ForecastQty)) although i do not

realise what was the problem,propable something with date comparison...

Refering to the vertical reference line is it possible to put it in without having continuous numeric filed in x-axis but having date format like 2012-12???

View solution in original post

6 Replies
Not applicable
Author

At least can anyone tell me if i have date format like : 1- 2009
                                                                              2- 2009

                                                                               ...........

in x-axis is there any way to put in a reference line??? There is  a restriction of all the x-axis values to be numeric so

what can i do.????

I tried the expression =num(month(Today())) + num(Year(Today())) but with no success....

Not applicable
Author

For you rfirst question, create a variable for your expression and then reference the variable.  This way it will only equal one data point. For the second, I am not very clear on what you need. Can you upload a sample?

Not applicable
Author

For the first question I made the variable vTODAY = date(today(),'YYYY-MM') is there any way to compare dates?? For example 2012-1>2013-1.I tried =if(date(b.TestMonthYear)<date(vTODAY),sum(b.QtyInvoiced),sum(b.ForecastQty))  but doesnot seem to work .

I also tried =if( 'b.TestMonthYear' < 'vTODAY', sum(b.QtyInvoiced),sum(b.ForecastQty)) which gives all correct results appart from the year 2013 when it gives 0.

For the second question in this particular case the x-axis will contain the dimention Date which will have the format 1-2012,2-2012...1-2013...etc ....but there is a restriction in reference lines refering to the x-axis which contain continuous numeric values so can i implement that...

Not applicable
Author

See if this is what you are looking for.  I used max(Date) for my date instead of Today(), just because I don't have data through today, but you could change that to suit your needs.

Not applicable
Author

Hi there rebeccad and thanks for your help,

This is not what i am looking for but fortunately i can explain whan i need with an example that was made by you.

What i want is the  same thing as demonstraden in your double line example but the period format will be like 2012-1.

You can notice that the actual is zero when i am in 2013 and i have forecast quantity but thats not correct the actual should equal

with the forcast value.I used the expressions mentioned in my earlier post in order to make it work but no luck. Oh one other thing the

reference line should be vertical and indicate todays date.....Thats all i hope you can help

Regards,

Nikolaos Kavroulakis

Not applicable
Author

I manage to implement the first part of my question by using the expression =if( SubField(b.TestMonthYear,'-',1) <= SubField(vTODAY,'-',1),if(SubField(b.TestMonthYear,'-',2) < SubField(vTODAY,'-',2),sum(b.QtyInvoiced),sum(b.ForecastQty)) ,sum(b.ForecastQty)) although i do not

realise what was the problem,propable something with date comparison...

Refering to the vertical reference line is it possible to put it in without having continuous numeric filed in x-axis but having date format like 2012-12???