topic Re: Text Function in QlikView

Text Function

Anonymous — Wed, 20 Aug 2014 16:43:16 GMT

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

Re: Text Function

amit_saini — Wed, 20 Aug 2014 16:45:32 GMT

Adotey,

Could you please elaborate more what exactly is the requirement.

Thanks,

Re: Text Function

martynlloyd — Wed, 20 Aug 2014 16:53:43 GMT

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

Regards,

Re: Text Function

Anonymous — Wed, 20 Aug 2014 17:04:38 GMT

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.

Re: Text Function

martynlloyd — Wed, 20 Aug 2014 17:07:59 GMT

In that case use Enable Conditional for the dimension and

TotalAmt > 500 AND not IsNum(MyField)

That will control the dimension.

regards,

Re: Text Function

Wed, 20 Aug 2014 17:11:58 GMT

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.

Re: Text Function

Anonymous — Wed, 20 Aug 2014 17:12:19 GMT

Awesome! Thanks