n objects conditions in single expression

Mon, 07 Mar 2011 07:08:50 GMT

hi,

can anyone give me a expression that should contain three objects condition in a single expression.

Thnks

n objects conditions in single expression

amars — Mon, 07 Mar 2011 07:19:18 GMT

Can you explain what do u mean by three objects condition in a single expression?

n objects conditions in single expression

Mon, 07 Mar 2011 07:47:22 GMT

hi amars, i provided my screenshot and what expressions used in QlikView file. Please check it.

for Input Here i am having 3 barcharts(IMM, Dose, PreCure) and 1 slider for each barchart.

for Output 1 barchart(LensMeasurements) with straight table for calculating Avg, Stdev, NumericCount.

Now when i am working with IMM barchart slider, then i should reflect the changes in "LensMeasurements Barchart"

and also the average of the LensMeasurements Barchart should also changes.

This process should work for all remaining barcharts(Dose, PreCure).

NOTE:

Actually i am using the below condition as Expression in LensMeasurements barchart. But when i am using, it is working fine only for IMMGroup and PreCureGroup but it is not working for DoseGroup. Can you check this expresion once what i written.

=Count({$<[$(=GetCurrentField([LensMeasurementsGroup]))]
=P({<[$(=GetCurrentField([IMMGroup]))]={">=$(g2ImmVar1)<=$(g2ImmVar2)"}>} [$(=GetCurrentField([LensMeasurementsGroup]))]),[CT Key]
=P({<[$(=GetCurrentField([IMMGroup]))]={">=$(g2ImmVar1)<=$(g2ImmVar2)"}>} [CT Key]),[CT Key]
=P({<[$(=GetCurrentField([DoseGroup]))]={">=$(g2DoseVar1)<=$(g2DoseVar2)"}>} [$(=GetCurrentField([LensMeasurementsGroup]))]),[CTKey]
=P({<[$(=GetCurrentField([DoseGroup]))]={">=$(g2DoseVar1)<=$(g2DoseVar2)"}>} [CT Key]),[CT Key]
=P({<[$(=GetCurrentField([PreCureGroup]))]={">=$(g2PreCureVar1)<=$(g2PreCureVar2)"}>} [$(=GetCurrentField([LensMeasurementsGroup]))]),[CT Key]
=P({<[$(=GetCurrentField([PreCureGroup]))]={">=$(g2PreCureVar1)<=$(g2PreCureVar2)"}>} [CT Key])>} [CT Key])

And also same for the Average calculation also it is working fine for two groups IMMGroup and PreCureGroup. But it is not working for DoseGroup, the below Expression i am using for calculating Average.

=num(avg({$<[$(=GetCurrentField([LensMeasurementsGroup]))]
=P({<[$(=GetCurrentField([IMMGroup]))]={">=$(g2ImmVar1)<=$(g2ImmVar2)"}>} [$(=GetCurrentField([LensMeasurementsGroup]))]),[CT Key]
=P({<[$(=GetCurrentField([IMMGroup]))]={">=$(g2ImmVar1)<=$(g2ImmVar2)"}>} [CT Key]),[CT Key]
=P({<[$(=GetCurrentField([DoseGroup]))]={">=$(g2DoseVar1)<=$(g2DoseVar2)"}>} [$(=GetCurrentField([LensMeasurementsGroup]))]),[CT Key]
=P({<[$(=GetCurrentField([DoseGroup]))]={">=$(g2DoseVar1)<=$(g2DoseVar2)"}>} [CT Key]),[CT Key]
=P({<[$(=GetCurrentField([PreCureGroup]))]={">=$(g2PreCureVar1)<=$(g2PreCurerVar2)"}>} [$(=GetCurrentField([LensMeasurementsGroup]))]),[CT Key]
=P({<[$(=GetCurrentField([PreCureGroup]))]={">=$(g2PreCureVar1)<=$(g2PreCurerVar2)"}>} [CT Key])>} [$(=GetCurrentField([LensMeasurementsGroup]))]), '###0.00000')

topic n objects conditions in single expression in QlikView

n objects conditions in single expression

n objects conditions in single expression

n objects conditions in single expression