topic Re: Graph help in QlikView

Graph help

Anonymous — Fri, 20 Feb 2015 16:54:15 GMT

I am looking for some help on the following graph:

I am using the following two formulas:

Bars -

(Sum({<MONTHYEAR ={">=$(=Date(addmonths(Max(MONTHYEAR), -14), 'MMM-YY')) <=$(=Date(addmonths(Max(MONTHYEAR), -1), 'MMM-YY'))"} , [NEW RENEW IND]={'COMBINED'}>} EIF) -

ABOVE(Sum({<MONTHYEAR ={">=$(=Date(addmonths(Max(MONTHYEAR), -14), 'MMM-YY')) <=$(=Date(addmonths(Max(MONTHYEAR), -1), 'MMM-YY'))"} , [NEW RENEW IND]={'COMBINED'}>} EIF)))

/1000

Line with dots -

Sum({<MONTHYEAR ={">=$(=Date(addmonths(Max(MONTHYEAR), -14), 'MMM-YY')) <=$(=Date(addmonths(Max(MONTHYEAR), -1), 'MMM-YY'))"} , [NEW RENEW IND]={'COMBINED'}>} EIF)/1000

I am trying to hide the dot for Oct-13, but show the bars as is currently displayed. When I try to change the line formula to -13, it causes an error with the access. Looking for some help to have the proper functionality.

Thank you,

Justin

Re: Graph help

Fri, 20 Feb 2015 16:57:26 GMT

Can you post sample .qvw with data.

Re: Graph help

Anonymous — Fri, 20 Feb 2015 17:29:02 GMT

Here is the attached QVW

Re: Graph help

Fri, 20 Feb 2015 17:35:54 GMT

Hi Justin,

I tried to change the line formula to -13 and the requirement is met.Its not causing any error for me. Attached the screenshot as well as qvw for reference.

Regards

Re: Graph help

buzzy996 — Fri, 20 Feb 2015 17:57:59 GMT

try,suppress null values on bar chart exp/dimension

Re: Graph help

Fri, 20 Feb 2015 18:42:07 GMT

same I tried and it is working fine

Re: Graph help

Anonymous — Fri, 20 Feb 2015 18:47:19 GMT

When I try the graph, here is the picture I get:

Re: Graph help

Anonymous — Fri, 20 Feb 2015 19:12:10 GMT

Shiva,

I tried to suppress the value and that did not alter the graph.

Rakesh and HareKrishna, what settings are you using to cause the normal graph, I have tried everything I can think of, and continue to get the result above. Also, did you change anything else in the expression?

Re: Graph help

Fri, 20 Feb 2015 20:15:14 GMT

The only change I made is -13 . Using exactly the same expression for Line:

Sum({<MONTHYEAR ={">=$(=Date(addmonths(Max(MONTHYEAR), -13), 'MMM-YY')) <=$(=Date(addmonths(Max(MONTHYEAR), -1), 'MMM-YY'))"} , [NEW RENEW IND]={'COMBINED'}>} EIF)/1000

What do you mean by settings here?

Re: Graph help

Anonymous — Fri, 20 Feb 2015 20:30:04 GMT

Just trying to figure out how yours shows

Re: Graph help

Anonymous — Fri, 20 Feb 2015 20:33:14 GMT

Just trying to figure out how yours shows as:

and mine shows as:

Just wondering if you had a different setting on as your legend is red and has different numbers shown than mine, or if you had something in your user properties. Also, could this be a bug or due to me being on a different service release?

Thanks for all the help,

Justin

Re: Graph help

Anonymous — Mon, 23 Feb 2015 15:26:52 GMT

HareKrishana,

Just wanted to see if you had any other thoughts on the matter of how I can fix this graph?

Thank you again,

Justin

Re: Graph help

buzzy996 — Thu, 26 Feb 2015 12:48:24 GMT

TRY LIKE THIS,

Re: Graph help

Anonymous — Thu, 26 Feb 2015 13:37:25 GMT

Shiva,

Thank you for the help. I am allowing the user to make a monthly selection over 2 years. With the graph being fluid, how can I take into account to block out the first month similar to your picture? It works great if I do not allow the user to make selections, but at the current time the request is to have monthly selections.

Thank you again,

Justin

Re: Graph help

buzzy996 — Thu, 26 Feb 2015 13:58:49 GMT

u can try to block only for which object expression ur getting null values not complete month

means i'm trying to blcok only oct-13 not oct-14.

Re: Graph help

Anonymous — Thu, 26 Feb 2015 14:02:21 GMT

Shiva,

Not sure I follow how to do that. When I suppress null values on the dimension tab, it does not seem to be fluid. eg. on the graph with no selections I want to block out Oct-13. But if the user then selections Oct-14, I would want to block out Sep-13. Based off of your if statement picture, is there a fluid formula that would cover this?

Thanks again,

Justin

Re: Graph help

buzzy996 — Thu, 26 Feb 2015 14:04:39 GMT

i don't think so apart from that,i can understand ur pain..have to think & come back again.......

Re: Graph help

Anonymous — Thu, 26 Feb 2015 14:09:47 GMT

Thank you again Shiva, I am set to get the most current service update today. I will let you know if that fixes any of the issues.