topic Re: Calculation Condition -Table Box in QlikView

Calculation Condition -Table Box

Tue, 19 Aug 2014 08:05:35 GMT

Hi, I want to insert a calculation condition in a table box. I have a field with 3 possible expressions in it - " S, A & T". Which formula can I use to exclude all fields/rows which is blank/ doesn't have any of these three possibilities in them? Thanks

Re: Calculation Condition -Table Box

avinashelite — Tue, 19 Aug 2014 08:08:58 GMT

Hi,

You cannot use calculated condition in the table Box. Use the calculated condition in the script.

try like

load *

from

where S<>'' and A<>'' and T<>''

Re: Calculation Condition -Table Box

Anonymous — Tue, 19 Aug 2014 08:12:49 GMT

Hi,

Calculated column is not possible in table object. You may have a look on straight table with specific expression or we have option to omit row in table object. See below,

Re: Calculation Condition -Table Box

ashfaq_haseeb — Tue, 19 Aug 2014 08:23:05 GMT

Hi,

You cannot create calculate condition.

But you can do aggregation in backed and use aggregated field in front end.

Regards

ASHFAQ