Solved: SetAnalyis with Difference - Qlik Community

Report Inappropriate Content · ‎2010-11-24

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

Report Inappropriate Content · ‎2010-11-24

Try something like:

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

Page 1 of 1 (1 items) | RSS

Report Inappropriate Content · ‎2010-11-24

Try something like:

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

Page 1 of 1 (1 items) | RSS

Report Inappropriate Content · ‎2010-11-24

Try something like:

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

Page 1 of 1 (1 items) | RSS