topic Re: how to write expression in script in QlikView

how to write expression in script

narender123 — Wed, 05 Jun 2013 07:48:55 GMT

I want to set an expression in script.

=if(GetSelectedCount(Import)=0,sum({<Year={$(=max(Year))},STATUS_CODE={350,360},REGIME={'C*'},Export=,TAXCODE={'ED'}>}TAX),sum({<Year={$(=max(Year))},STATUS_CODE={350,360},Export=,TAXCODE={'ED'}>}TAX))

I have written this expression in chart expression using set analysis .Now i want it to write in Script level.How to write it???

Thanks

Re: how to write expression in script

narender123 — Wed, 05 Jun 2013 08:09:23 GMT

Could you please give me some suggestion to write this expression in script??

sum({<Year={STATUS_CODE={350,360},REGIME={'C*'},Export=,TAXCODE={'ED'}>}TAX)

Re: how to write expression in script

er_mohit — Wed, 05 Jun 2013 09:14:01 GMT

Try this

if(widmatch(STATUS_CODE,'350','360') or match(REGIME,'C*') or TAXCODE='ED',TAX) as TAX

hope it helps

Edited by Me:--

Sorry by mistake i write Or condition

if(widmatch(STATUS_CODE,'350','360') and match(REGIME,'C*') and TAXCODE='ED',TAX) as TAX

here you don't want to mention the sum simply in your expression used Sum(TAX) because your subtotal works on the basis of sum(fieldname)

your TAX field value is just like in expression sum(TAX) if you want total then put sum in expression then it gives the overall total which you get in expression like this way

sum(total TAX)

hope it helps

Re: how to write expression in script

narender123 — Wed, 05 Jun 2013 09:16:20 GMT

I dont understand with your or conditions as in my expression there is and condition .

So Please tell me

Thanks.

Re: how to write expression in script

Wed, 05 Jun 2013 09:24:08 GMT

Hi,

How about:

if( (STATUS_CODE='350' or STATUS_CODE='360') and left(REGIME,1)='C' and TAXCODE='ED', TAX) as TAX

Regards,

Lester

Re: how to write expression in script

narender123 — Wed, 05 Jun 2013 09:27:03 GMT

Hi Lester,

But there is no sum condition.

Thanks

Re: how to write expression in script

jagan — Wed, 05 Jun 2013 09:44:36 GMT

Hi Narendar,

Use Sum(TAX) in your expression or else calculate the sum in Load script by using

Tax:

LOAD

Sum(TAX) AS TotalTax

FROM TableName;

Hope this helps you.

Regards,

Jagan.

Re: how to write expression in script

narender123 — Wed, 05 Jun 2013 09:51:58 GMT

Hi Mohit,

Thanks for your reply.

But its not working. see the attached file.

Re: how to write expression in script

narender123 — Wed, 05 Jun 2013 09:54:06 GMT

Hi Jagan,

Thanks for your reply

could yopu please give the solution of whole expression in script means how to write it on script level.

sum({<Year={STATUS_CODE={350,360},REGIME={'C*'},Export=,TAXCODE={'ED'}>}TAX)

Re: how to write expression in script

jagan — Wed, 05 Jun 2013 14:44:06 GMT

Hi,

Try like this

Table1:

LOAD

If((STATUS_CODE= 350 OR STATUS_CODE= 360) AND LEFT(REGIME)='C' AND TAXCODE='ED', TAX, 0) AS CalculatedTax

FROM DataSource;

Tax:

LOAD

Sum(TAX) AS TotalTax

FROM Table1;

Now you can just use TotalTax in your expression.

Hope this helps you.

Regards,

Jagan.

Re: how to write expression in script

narender123 — Thu, 06 Jun 2013 11:35:12 GMT

Thank you all for the support.