Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
durgabhavani
Creator III
Creator III

help me in writing expression?

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

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

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

740321.png

View solution in original post

29 Replies
sushil353
Master II
Master II

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

Not applicable

Hi Durga,

Just you remove those fields from  your chart(dimensions)

Priyantha.

durgabhavani
Creator III
Creator III
Author

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

Durga

durgabhavani
Creator III
Creator III
Author

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

Durga

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

Use this for the calc dimension:

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
sushil353
Master II
Master II

can you share your sample app ?

anbu1984
Master III
Master III

In script,

Load * From Table

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

durgabhavani
Creator III
Creator III
Author

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


anbu1984
Master III
Master III

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

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