topic SetAnalyis with Difference in QlikView

SetAnalyis with Difference

Wed, 24 Nov 2010 19:29:24 GMT

Hello Guys,

How can I make this work? The main problem is {<StdpcsSec>}-{<SetpcsSec>} ) which it does not take. The otherpart works good.


=sum({<ProductCategory = {'G'}>}ActivityDuration*StandardValueAddedTime*{<StdpcsSec>}-{<SetpcsSec>} )

Thanks

Sravan

Wed, 24 Nov 2010 19:50:04 GMT

Try something like:

=sum({<ProductCategory = {'G'}>}ActivityDuration*StandardValueAddedTime*((StdpcsSec)-(SetpcsSec)))

Page 1 of 1 (1 items) | RSS

Wed, 24 Nov 2010 19:50:09 GMT

Try something like:

=sum({<ProductCategory = {'G'}>}ActivityDuration*StandardValueAddedTime*((StdpcsSec)-(SetpcsSec)))

Page 1 of 1 (1 items) | RSS