Solved: How to Make a graph with the differences - Qlik Community

Report Inappropriate Content · ‎2010-12-09

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

johnw · ‎2011-02-28

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)

View solution in original post

Report Inappropriate Content · ‎2010-12-09

No Ideas?

maneshkhottcpl · ‎2010-12-09

can u send the application?

Anonymous · ‎2010-12-09

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.

Report Inappropriate Content · ‎2010-12-10

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>

Report Inappropriate Content · ‎2010-12-10

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

Report Inappropriate Content · ‎2010-12-10

edit

Report Inappropriate Content · ‎2010-12-13

Any ideas here??

Report Inappropriate Content · ‎2010-12-13

Edit

Report Inappropriate Content · ‎2011-02-28

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