topic Re: Problems viewing graph scatterplot by rank months in QlikView

Problems viewing graph scatterplot by rank months

Anonymous — Wed, 17 Feb 2016 17:00:29 GMT

Good morning everyone, I need your support in order to display a scatter plot I need to develop, the expressions that I use are:

Expr1: Only ({<[Year Time - Cost] = eaMarino :: [Year Time - Cost], Management = { 'Terrestrial'}, [Month Time - Cost] = { '> (= min ([Month Time - Cost ]) <(= max (eaMarino :: [Month Time - Cost]) '}>} [Actual Cost])

Expr2: Only ({<[Year Time - Cost] = eaMarino :: [Year Time - Cost], Management = { 'Terrestrial'}, [Month Time - Cost] = { '> (= min ([Month Time - Cost ]) <(= max (eaMarino :: [Month Time - Cost]) '}>} [Planned Cost])

The detail that I have is that when I add the expression of the month ([Month Time - Cost] = { '> (= min ([Month Time - Cost]) <(= max (eaMarino :: [Month Time - Cost ]) '}), not shown the graph, show the leyend "no data to be displayed", but they do exist.

The data come from the selection in an alternate state called eaMarino.

in my condition I require is that to indicate a month, for example, the information is displayed March from January to March inclusive.

In advance thank you very much by support to my problem.

I look forward to your comments.

Kenneth Baeza

Re: Problems viewing graph scatterplot by rank months

sunny_talwar — Wed, 17 Feb 2016 18:38:22 GMT

What is the format for [Month Time - Cost]? Format's need to match on the LHS and RHS of the set modifier. Min(Month) would be a number and wouldn't equal Jan, Feb, ... etc. So you need to somehow get the LHS and RHS in the same formats to get this working

Re: Problems viewing graph scatterplot by rank months

Anonymous — Wed, 17 Feb 2016 22:04:41 GMT

Thanks for your comment Sunny T, both values have shaped the text, Jan, Feb, ..., I made the switch to numeric format by changing the value of MonthNames

SET MonthNames = '1; 2; 3; 4; 5; 6; 7; 8; 9; 10; 11; 12';

even so, I do not get to see the graph.

thanks for you support.

Kenneth Baeza

Re: Problems viewing graph scatterplot by rank months

sunny_talwar — Thu, 18 Feb 2016 02:41:44 GMT

Would you be able to share a sample to look at the issue?

Re: Problems viewing graph scatterplot by rank months

Anonymous — Thu, 18 Feb 2016 18:16:35 GMT

Of course, attached application, I use a Personal Edition version.

Regards.

Kenneth Baeza