topic Re: Needed help in an expression in QlikView

Needed help in an expression

ferha_jafri — Wed, 16 Mar 2016 12:40:50 GMT

Hello Everyone,

I need help in writing an expression in text box as if max(MY) is present in the Field then print the message as present or absent . Not sure how to achieve it. Attaching the sample application.

Re: Needed help in an expression

sunny_talwar — Wed, 16 Mar 2016 12:46:38 GMT

May be this:

=If(SubStringCount(Concat(Filename),$(vMonthId)) > 0 ,1, 0)

Changed the variable to this: Max(Num#(MY, '##'))

Re: Needed help in an expression

Anonymous — Wed, 16 Mar 2016 12:48:24 GMT

try like this?

Take a variable, say:

Let VMax=max(FieldName);

Then in Text Box try this?

If(FieldName='$(VMax)', 'Present', 'Absent')