topic Re: help me in writing expression? in QlikView

help me in writing expression?

durgabhavani — Thu, 26 Mar 2015 04:33:01 GMT

Hi All,

I have field billing

billing

accounts

payment

tenders

dues section

fines section

I am using billing field as dimenstion, now i dont want to display tenders and dues section columns in my chart?

Can anyone please help me ASAP.

Thanks,

Durga

Re: help me in writing expression?

sushil353 — Thu, 26 Mar 2015 04:59:01 GMT

hi,

In your dimension> edit the dimension

if( Billing = 'tenders' or Billing = 'dues section' , null(),billing)

Check the option for hide null values.

HTH

sushil

Re: help me in writing expression?

Thu, 26 Mar 2015 05:00:31 GMT

Hi Durga,

Just you remove those fields from your chart(dimensions)

Priyantha.

Re: help me in writing expression?

durgabhavani — Thu, 26 Mar 2015 05:07:07 GMT

Sushil not getting any changes to chart after giving condition. i used suppress when values is null also.

Durga

Re: help me in writing expression?

durgabhavani — Thu, 26 Mar 2015 05:08:08 GMT

how to remove field in edit script without going to source data.

Durga

Re: help me in writing expression?

jonathandienst — Thu, 26 Mar 2015 05:25:19 GMT

Use this for the calc dimension:

=Aggr(Only({<billing -= {'tenders', 'dues section'}>} billing), billing)

HTH

Jonathan

Re: help me in writing expression?

sushil353 — Thu, 26 Mar 2015 05:27:52 GMT

can you share your sample app ?

Re: help me in writing expression?

anbu1984 — Thu, 26 Mar 2015 05:31:05 GMT

In script,

Load * From Table

Where Not (Billing = 'tenders' or Billing = 'dues section');

Re: help me in writing expression?

durgabhavani — Thu, 26 Mar 2015 05:34:26 GMT

it showing syntax error under { besided 'tenders. I cross checked, everything i kept fine. but showing error.

Re: help me in writing expression?

anbu1984 — Thu, 26 Mar 2015 05:57:09 GMT

It's not syntax error. Red marks are due to minus used in Set analysis

=Aggr(Only({<billing -= {'tenders', 'dues section'}>} billing), billing)

Re: help me in writing expression?

durgabhavani — Thu, 26 Mar 2015 06:13:44 GMT

no it is clearly showing syntax error under { beside tenders. but expression is ok. I am not get output as required.

Re: help me in writing expression?

petter — Thu, 26 Mar 2015 06:19:34 GMT

it is a well known bug in the syntax highlighter/checker that has been there for years...

Re: help me in writing expression?

sunilkumarqv — Thu, 26 Mar 2015 06:28:38 GMT

Try like this in your calculated dimension

if( billing <> 'tenders' and billing <> 'dues section' ,billing)

Re: help me in writing expression?

durgabhavani — Thu, 26 Mar 2015 08:00:15 GMT

bars are displaying still now.

Re: help me in writing expression?

durgabhavani — Thu, 26 Mar 2015 08:02:56 GMT

Please advice me to display bars whatever i required?

Re: help me in writing expression?

anbu1984 — Thu, 26 Mar 2015 08:05:47 GMT

Can you post sample app

Re: help me in writing expression?

durgabhavani — Thu, 26 Mar 2015 08:35:59 GMT

I have no access to post sample app, I just want to hide the particular bars (unnecassary which is not required to client) in bar chart

Otherwise if I am able to display particular bars also fine.

I am trying to write calicualted dimension but not get output.

Thanks,

Durga

Re: help me in writing expression?

anbu1984 — Thu, 26 Mar 2015 08:46:28 GMT

check this

Re: help me in writing expression?

durgabhavani — Thu, 26 Mar 2015 08:57:01 GMT

Hi Anbu,

Please give me the screenshot, i have no access to download and upload in office.

Waiting for your reply!

Durga

Re: help me in writing expression?

anbu1984 — Thu, 26 Mar 2015 09:05:07 GMT

Load * Inline [

billing,payment

tenders,100

dues section,200

aaa,50

bbb,60 ];

In Chart,

Calculated dimension: =Aggr(Only({<billing -= {'tenders', 'dues section'}>} billing), billing)

Expr: sum(payment)

Check "Suppress When Value is NUll" in chart