Text Function

[Anonymous]

If total amount is greater then 500 show content of the field.where the field contains text string, what function will display just that content.

Thanks

[amit_saini]

Adotey,

Could you please elaborate more what exactly is the requirement.

Thanks,

AS

[martynlloyd]

If(TotalAmt > 500 AND not IsNum(MyField), Myfield)

Regards,

M.

[Anonymous]

Hi

Thanks for the quick response I'd hope to used the expression as a calculated dimension which does not display but works fine when used as am expression.

[martynlloyd · Accepted solution]

In that case use Enable Conditional for the dimension and

TotalAmt > 500 AND not IsNum(MyField)

That will control the dimension.

regards,

M.

[#6]

Hi,

I'm not sure understand your request but I can see you need show your amount data only if amount > 500 and value of amount field is numeric you just have to create a set analysis to specify DimensionField > 500, the expressions could be like this:

sum({<ProductID={"=Sum(Amount)>500"}>}Amount)

You don't need specify If my amount value is numeric show me amount because qlikview's natural behaviour sum only numeric values.

See attached file.

I hope it will be usefull for you. Best regards.

[Anonymous]

Awesome! Thanks