topic Re: set analysis based on intersecting events in QlikView

set analysis based on intersecting events

Wed, 27 Jan 2016 17:10:01 GMT

Hi, I'm having trouble figuring out how to write this as set analysis in an expression:

=AVE( [Cost of Car]/[Price of Car])

Where....

[Cost of Car] is >0

AND

[Price of Car} is not NULL

I'm trying to get to the average (percent) of cost divided by price - where the cost is greater than $0, and the field that contains the price is not empty.

Any ideas? Thanks.

Re: set analysis based on intersecting events

Gysbert_Wassenaar — Wed, 27 Jan 2016 17:57:08 GMT

avg({<[Cost of Car]={">0"},[Price of Car]={'*'}>} [Cost of Car]/[Price of Car])

Re: set analysis based on intersecting events

sunny_talwar — Wed, 27 Jan 2016 18:10:31 GMT

Or this:

=Avg({<[Cost of Car]={">0"}, [Price of Car] = {"=Len(Trim([Price of Car])) > 0"}>}[Cost of Car]/[Price of Car])

Re: set analysis based on intersecting events

Wed, 27 Jan 2016 18:48:42 GMT

Thanks; I had that but wasn't getting the right answer. Turns out I had duplicate VINs where both cars had a price, but only one had a cost which was giving me an answer that was half of what it should have been.