topic How to Make a graph with the differences in QlikView

How to Make a graph with the differences

Thu, 09 Dec 2010 10:47:42 GMT

Hello Guys,

The graph does not see good if I select the CounterRdgDifference

How Can I get this correct as I dont want this firstvalue to be seen.

Thanks

sravan

How to Make a graph with the differences

Thu, 09 Dec 2010 14:32:08 GMT

No Ideas?

How to Make a graph with the differences

maneshkhottcpl — Thu, 09 Dec 2010 14:47:51 GMT

can u send the application?

How to Make a graph with the differences

Anonymous — Thu, 09 Dec 2010 17:30:07 GMT

Sravan,

You can hide it by using calcualted dimension. But, I think, it is not the correct solution. The better way is to change your expression for the "difference" column so it will be blank in the earliest day.

How to Make a graph with the differences

Fri, 10 Dec 2010 14:43:51 GMT

Hallo Michael,

Thanks for the Reply. Ya I also thought same with Calculated Dimension but it is not the correct Solution. I dont know how to change the Expression. Peek ??

The Expression is this


= Sum(DifferenceReading)
[/n code]

Any suggestions how to get the first value here Blank

Thanks
sravan</body>

How to Make a graph with the differences

Fri, 10 Dec 2010 14:53:15 GMT

I did this and get the correct answer but still can I do in the script some changes?


= if(sum(MeasuringReading) =sum(DifferenceReading), null(), Sum(DifferenceReading))

How to Make a graph with the differences

Fri, 10 Dec 2010 17:37:09 GMT

edit

How to Make a graph with the differences

Mon, 13 Dec 2010 09:38:56 GMT

Any ideas here??

How to Make a graph with the differences

Mon, 13 Dec 2010 09:59:11 GMT

Edit

How to Make a graph with the differences

Mon, 28 Feb 2011 15:32:34 GMT

Hello,

Can any one help with the attached .qvw. I thought I got it before but still it is a problem.

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.00.49.52/measuringPointstest123.qvw]

Thanks in advance.

Sravan

How to Make a graph with the differences

Mon, 28 Feb 2011 18:34:27 GMT

I hope someone can help me.

Thanks a lot

sravan

How to Make a graph with the differences

johnw — Mon, 28 Feb 2011 21:22:15 GMT

I believe this:

sum(aggr(if(MeasuringReading<>DifferenceReading, DifferenceReading), Calendar.Year, Calendar.Month, Calendar.Day))

However, what I'd do instead is fix the difference reading as you load the data:

if(MeasuringReading<>DifferenceReading,DifferenceReading) as DifferenceReading

Then you can just use this:

sum(DifferenceReading)